PDA

View Full Version : URGENT Filemaker Pro help required - please



Jaffa
26th June 2008, 06:55 PM
Okay guys, thanks for coming here.

Now I am finishing off an assignment for tomorrow, and everything in the database works except one little thing, which is causing one of my forms to display blank fields on part of the form.

Here is my relationship diagram:

http://img.skitch.com/20080626-cphcfs5wfsgnqmus1krsg48ydw.jpg

All I have to do is create a relationship between Product ID in the Products table and Product ID in the Quotes table and it should work, but it wont let me do that, telling me that:

http://img.skitch.com/20080626-11nrwt9id24kkajngccsw1awb4.jpg

And if I press Okay, and make the second entity as Quotes 2 it still does not work and functions just as if the relationship there didnt exist...

If anyone has any ideas could you *please* let me know how to fix it cause I have tried everything I can possibly think of...

Cheers,

Jeff

Jaffa
26th June 2008, 07:09 PM
Me figured it out :D:D

AND now I see how it has to be done! I was trying to relate The Products table to the Quotes, but I had to do it the other way around! :D:D

http://img.skitch.com/20080626-kuyhuhuj7c4784knkdbuc69w7b.jpg

Thank you telepathic people who gave me the idea :D

SyncMan
27th June 2008, 06:03 AM
Okay, since I have a vague idea about this, I will except thanks, without looking into further detail.