Jump to content

sub-tables?


imetu
 Share

This topic is 5682 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi, i am trying to build a database that contains a table for Customers. For each customer in the table i want to store possibly hundreds of records.

I did set up another table called "items" and tried to relate this to the customer using the common "customerID" field, but i dont know how to make it so that when i enter a new customer in to the customer table, i get a clean slate when i go to enter the data for the new customer into the items table.

I don't know how clear that is. I thought i could somehow build in a sub-table for each customer in the customer table but i dont know enough of fmp to know how to do it. Maybe someone out there knows of some idiot proof instructions that they could point me to. Or have some terms that i can search for information in the fmp online help. My problem here is that i dont know what to search for with what i am trying to do.

Any help would be appreciated. my email is [email protected]

thank you in advance for your help and ideas

imetu

Link to comment
Share on other sites

Look up "portals" and "relationships" in the FileMaker help. A portal showing the related Items is the way to go. Make sure the relationship definition has "Allow creation of records in this table via this relationship" checked on the Items side.

Link to comment
Share on other sites

This topic is 5682 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.