Field type txt or nos for relating to autonumber field ?
in [Tables]
|
Prev: Default Values
Next: consultation card template
From: Steve on 20 Jun 2008 18:41 Hi, Should I make the field called ID in my second table a number or text type of field when that field relates to my first table's primary key field called ID which is an Autonumber field or does it not matter ? This second tables PrimaryKey field will be called PhotoID by the way. Steve
From: Jeff Boyce on 20 Jun 2008 19:01 Steve An Access Autonumber is a long integer. You'll need to have a "compatible" data type in your second table (i.e., a Long Integer). Regards Jeff Boyce Microsoft Office/Access MVP "Steve" <dornier(a)blueyonder.co.uk> wrote in message news:%239L%23Rby0IHA.3968(a)TK2MSFTNGP04.phx.gbl... > Hi, > Should I make the field called ID in my second table a number or text type > of field when that field relates to my first table's primary key field > called ID which is an Autonumber field or does it not matter ? > > This second tables PrimaryKey field will be called PhotoID by the way. > > Steve >
From: Steve on 20 Jun 2008 19:41 Hi Jeff, I have field type for the field that relates to the primary key of the first table, as Number and its LongInteger so guess thats ok. Steve "Jeff Boyce" <nonsense(a)nonsense.com> wrote in message news:eyofOmy0IHA.3884(a)TK2MSFTNGP05.phx.gbl... > Steve > > An Access Autonumber is a long integer. You'll need to have a > "compatible" data type in your second table (i.e., a Long Integer). > > Regards > > Jeff Boyce > Microsoft Office/Access MVP > > > "Steve" <dornier(a)blueyonder.co.uk> wrote in message > news:%239L%23Rby0IHA.3968(a)TK2MSFTNGP04.phx.gbl... >> Hi, >> Should I make the field called ID in my second table a number or text >> type of field when that field relates to my first table's primary key >> field called ID which is an Autonumber field or does it not matter ? >> >> This second tables PrimaryKey field will be called PhotoID by the way. >> >> Steve >> > >
From: Jeff Boyce on 20 Jun 2008 19:49 If you tried to use "Text" and then told Access to relate the two on those fields, Access would "choke" and tell you something about a "data type mismatch". Regards Jeff Boyce Microsoft Office/Access MVP "Steve" <dornier(a)blueyonder.co.uk> wrote in message news:uicsY8y0IHA.2384(a)TK2MSFTNGP02.phx.gbl... > Hi Jeff, > I have field type for the field that relates to the primary key of the > first table, as Number and its LongInteger so guess thats ok. > Steve > > "Jeff Boyce" <nonsense(a)nonsense.com> wrote in message > news:eyofOmy0IHA.3884(a)TK2MSFTNGP05.phx.gbl... >> Steve >> >> An Access Autonumber is a long integer. You'll need to have a >> "compatible" data type in your second table (i.e., a Long Integer). >> >> Regards >> >> Jeff Boyce >> Microsoft Office/Access MVP >> >> >> "Steve" <dornier(a)blueyonder.co.uk> wrote in message >> news:%239L%23Rby0IHA.3968(a)TK2MSFTNGP04.phx.gbl... >>> Hi, >>> Should I make the field called ID in my second table a number or text >>> type of field when that field relates to my first table's primary key >>> field called ID which is an Autonumber field or does it not matter ? >>> >>> This second tables PrimaryKey field will be called PhotoID by the way. >>> >>> Steve >>> >> >> > >
From: Steve on 21 Jun 2008 12:17
Hi Jeff, Good to know, my gut instinct is choose type Number for a field to relate to a PrimaryKey field, as opposed to Text, confirmed by your answers so I should be ok. Steve "Jeff Boyce" <nonsense(a)nonsense.com> wrote in message news:OBuEPBz0IHA.1572(a)TK2MSFTNGP05.phx.gbl... > If you tried to use "Text" and then told Access to relate the two on those > fields, Access would "choke" and tell you something about a "data type > mismatch". > > Regards > > Jeff Boyce > Microsoft Office/Access MVP > > "Steve" <dornier(a)blueyonder.co.uk> wrote in message > news:uicsY8y0IHA.2384(a)TK2MSFTNGP02.phx.gbl... >> Hi Jeff, >> I have field type for the field that relates to the primary key of the >> first table, as Number and its LongInteger so guess thats ok. >> Steve >> >> "Jeff Boyce" <nonsense(a)nonsense.com> wrote in message >> news:eyofOmy0IHA.3884(a)TK2MSFTNGP05.phx.gbl... >>> Steve >>> >>> An Access Autonumber is a long integer. You'll need to have a >>> "compatible" data type in your second table (i.e., a Long Integer). >>> >>> Regards >>> >>> Jeff Boyce >>> Microsoft Office/Access MVP >>> >>> >>> "Steve" <dornier(a)blueyonder.co.uk> wrote in message >>> news:%239L%23Rby0IHA.3968(a)TK2MSFTNGP04.phx.gbl... >>>> Hi, >>>> Should I make the field called ID in my second table a number or text >>>> type of field when that field relates to my first table's primary key >>>> field called ID which is an Autonumber field or does it not matter ? >>>> >>>> This second tables PrimaryKey field will be called PhotoID by the way. >>>> >>>> Steve >>>> >>> >>> >> >> > > |