Newbie with a Question

[arvitat]

Hi there,

I was wondering how to insert a sub table, or the FM equivalent of one. The terminology is slightly different from that of MS Access and I'm having trouble finding the tools I need.

Thanks in advance!

[RalphL]

A sub table would be a table with a one to one relationship to the primary table. An alternate would be to have all data in one table and use different layouts to show the fields that would be in a sub table.

[Himitsu]

just go to define databases and it should bring up the fields box. If you look at the tabs, you should see 3. The very left one is the table area. click on that one and at the bottom you can create a new table then go to the fields tab, add the fields, then go to the relationships tab and connect them. Is that what you mean?

[arvitat]

Well, I guess I'm wondering how to have them show & be able to refresh the sub table, without having to re-enter the main table's information. I'm trying to put together an invoice layout where I can enter the customer information and multiple items purchased. The way its going right now is creating a new record for every item ordered. Maybe Access did it that way as well and I just didn't realize it. I guess I'll keep trying. Thank you for trying to help!

[Himitsu]

That is what we call a lineitem table. If you ever want to show each item a customer has bought, then a lineitem system works good. Have a table for the customer, a table for the sales, and a table for the lineitems. The portal on the sales is from the line items. To start, it is a good idea to make almost the same fields that the sales table has on the lineitems table. I have a file I put up under emailing invoices post that is basically a very simple register but does keep track of customers by phone number. If you want, downlaod it and see what relationships I made and keep in mind when making it, the relationship from the sales table to the lineitems needs to have the check box allowing new records to be made through the relationship. Let me know how it is going.

here is the link.

http://www.fmforums.com/threads/showflat...true#Post133037