I have a customer table, and invoice table, an invoice items table (for the individual items purchased) and a products table. All works until I try to add a drop down to select the product as only one item is listed.

Are are any examples around of how to set this type of relationship up?

If you pay attention to a contemporary thread...

http://www.fmforums.com/forum/showtopic.php?tid/193120/post/280701/#280701

...and use some of it in connection with this:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000717

--sd

Also, have a look at this demo (yes, I'm bored today, Soren!)

Topic_193121.zip

Edited February 8, 200817 yr by Guest