Datatypes

[Tonya]

I wanted to find out what data type i have to use in a
child table that has a foreign key to a parent table that
uses an autonumber.


I.e table 1
Booking Number = autonumber


table 2
Booking number = ???????? (what do i put here to hold
the autonumber generated by table 1? should i use
autonumber again?

thank u for your help

 

[Van T. Dinh]

Long

 

[Tonya]

thank u.

Will the autonumber be automatically be passed ono the
child tables if i have it as long??

 

[John Vinson]

Will the autonumber be automatically be passed ono the
child tables if i have it as long??

No, that's not how relationships work! If you use a Form for your main
table; a Subform for the child table; the Autonumber field as the
Master Link Field property of the subform, and the Long Integer field
as the Child Link Field it will fill it in automatically, but not just
in a table datasheet.