copy values from 1 table to another on click

[gjerome]

I have two tables (contacts & scheduling) with a 1 to 1 relationship, matched on ID.

I did this as access wouldn't allow me to make a table with more than 255 fields.

I have a form with source=contacts (autonumber ID) with a button that opens the scheduling form presenting only the record with matching ID.

Is there code I can write for the button that will set the ID on scheduling to match the (autonumber)ID on contacts if there isn't already such a record?

Is there another, easier approach to take?

thanks in advance

JJJ

 

[Darrylles]

Hiya,

Yes, there is - design your database correctly.

Why 255+ fields?

Regards,

Darrylles "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[gjerome]

Here is the actual situation:
we are tracking participants in a study
we track the following information for each participant
general contact info 20 fields
prescreening questions 30 fields
test scheduling 10 fields X 6 time points 60 fields
behavior tracking 20 fields/week x 24 weeks

total: 590 fields

currently each of the above categories has its own table

very open to constructive comments to
1) answer original q
2) explain a better way to organize

JJJ

 

[Darrylles]

Hi again,

Does a 'Contact' only ever have ONE schedule?
Do you only ever have this contact shown ONCE in your application?

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[gjerome]

'Contact' only has one schedule.

Each ID number corresponds with a unique participant who is associated with 590 pieces of info.

Unlike tracking books were many books may have the same author or publisher and a separate table can be used to track info on the authors and publishers.

Each piece of info from the participant is unique. Of course many participants may have provided the same response (i.e. of 200 people, 2 have the same b-day) or test date (i.e. 5 of 200 people are tested 15/2/03)


JJJ