In Manage | database | relationships you have this relationship?
Orders::ArticleID = Articles::ArticleID
On your layout, when you enter layout mode and open layout setup...., what do you see in the "show records from" drop down?
Doh! I completely misunderstand the way FM works - I assumed < meant "one to many" as in - from one to many entries. Instead FM does it automatically and I had to put = in its place. *facepalms*
Well now that I'm here anyway, I have another question: if I wanted to create an invoice where I add elements from article info and order info (as in, amounts ordered, article description and ID) how would that be done?
The idea is that you can add as many as you want and if you run out of room, it would let you print to a second page. I'd like to be able to just enter the order ID and have it be added without having to manually type it as well - the order ID contains all the needed info.
Theres an Invoices starter solution that comes with FileMaker you can look at. This .fp7 demo file (should convert fine to version 12 format), is a simpler and easier to understand file that is set up in much the same fashion: http://fmforums.com/forum/showpost.php?post/309136/
THanks! This should help a great deal.
If I can get a good solid database set up, I'm hoping to convince my boss to buy FM (using a trial at the moment) instead of messing with Excel and fiddling with manually filled out invoices. She spends about an hour each morning printing labels by typing them by hand (they go on the boxes with article info which should be doable with FM as well) - she wastes tons of time a week like that.