Can't get invoice items to work

[Kevin Cheesman]

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?

[Søren Dyhr]

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

[bcooney]

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

Topic_193121.zip

Edited February 8, 2008 by Guest