Jump to content

dynamic relational database structure


rblau
 Share

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

Recommended Posts

  • Newbies

I am using Filemaker 7.

I have a client table that has my client information. I have another table

that has many items related to that client.

I have a third table that maps a unique client ID with the many unique Item

IDs related to that client.

What I want to be able to do is while I am inputting the client information,

save the unique client ID and then while I am inputting the related items in

the other table have that unique item and the client ID item put in my

mapping table automatically.

How can this be done?

Rob Blau

FileMaker Version: 7

Platform: Mac OS X Jaguar

Link to comment
Share on other sites

Rob,

I don't understand why you need the join table. Why not directly relate the client table to the client information table? You can use a portal on a client table layout to update the client information.

Mike

Link to comment
Share on other sites

This topic is 6495 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.