Orders database design?
I'm using FileMaker Pro v13.0v1 (Mac).
I'd like to create an orders database. The database should contain customer information, order date, etc.,etc., but also a variable number of "lines" for what's being ordered. By "lines" I mean that's what it would look like if it were printed.
The customer info, pickup info, etc. is easy enough but it's the order items part I can't figure out. I'm not even sure what to call what I want. Portals are limited to a fixed number of visible fields so that's not good.
Any thoughts on how to do this or an example orders database?
Thanks for any help..