Auto population based on related calculation

[comicsans12pt]

Hi.

I'm very new at FM and haven't touched a DB in years. I'm also pretty sure there's something wrong with the way i've set up my tables so any and all help is appreciated.

First table has two fields:

Date of approval (1) PK (This is a unique value)

Class type (1) (This is made up of recurring values)

Second table has a whole bunch of fields but the ones that are relative are:

Date of approval (2)

Class type (2)

(Neither of these are PK)

Now, ideally i would like:

Class type (2) to pull all the values from Class Type (1) as a drop down;

Then, once the Class Type (2) is selected:

The Date of Approval (1) associated with the chosen record in Class Type (2) auto-populates to Date of Approval (2).

Since i will be creating multiple records using the (2) fields, they really aren't candidates for just adding to the first table (are they?)

Is this possible or should i be setting this up some other way?

I'm using FM Pro 10.v3

Thanks so much. cs12

[Vaughan]

Don't use the date of approval for the primary key. The pk should be an auto-entered serial number that doesn't get used for anything else and has no meaning.