Jump to content

Creating New Records via Relationships


saraheagle
 Share

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

Recommended Posts

Hi, I realize that this is a pretty stupid question but I've been staring at my database for a solid couple of days now and I've been frantically sifting through my Missing Manuel, so thank you in advance for any/all advice.

I am creating a database for a photography collector, I have one "Master" table that I call Photographs which contains a unique record for each photograph in the collection. I also have an "Artist/ Organization" table. Both have an "Artist/ Organization" field, which is what I am using to connect the two tables.

My goal is to be able to put an Artist's name in the "Artist/ Organization" field in the Photography table and have it automatically create a new record with that Artist's name in the corresponding field in the Artist/ Organization table. I have checked the boxes "create new records via this relationship" on the side of "Artist/ Organization" but it doesn't seem to be working. Am I missing something?

Again, thank you in advance for all of your help and please let me know if you have any questions.

Link to comment
Share on other sites

The reason why no record is created in the Artists table is (I think) that you are not entering the name into a field in the Artists table. However, the way you are going about this is flawed on two counts:

1. Your relationship should be based on ArtistID (an auto-entered serial number field in the Artists table) rather than on a name. Names change, get misspelled, etc.

2. In your proposed method, if you enter the artist's name as "Adam", a new record will be created in the Artists table - even if a record for Adam already exists.

See also:

http://fmforums.com/forum/index.php?showtopic=76385&view=findpost&p=359668

Link to comment
Share on other sites

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