How can I create "subrecords' within a record? For example, I make a record for a company and want to list their various products, prices, etc....so it looks like this:

Name of company Product name Price

How can I create "subrecords' within a record? For example, I make a record for a company and amongst the various information I have for the company, I also want to list their various products, prices, etc and continue to add to it easily....so it looks like this. The only option I can find a portal but that isn't what I want. The other options is I need to make fields each time I add a new product but that isn't very efficient. So basically is there a subrecord option? Thanks!

Name of company Product name Price Availability Misc

1.

2.

3.

4.

How can I create "subrecords' within a record? For example, I make a record for a company and want to list their various products, prices, etc....so it looks like this: Name of company Product name Price

You create another table Products (with fields like price), which you match (link) to the Company table via the Company table's primary key. Then you can add any number of products for a company, and in each table show related data from the other one.

In your FileMaker Online help, read the topic Home > Designing and creating databases > Working with related tables and files, as well as the “related” topics.

btw, somehow you posted this message three times.

Your structure should be to have a related table or perhaps even a couple of related tables.

P.S. I merged your triple posts.