If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking tables
Which datatype is best to use for the fields used in linking tables? I know
Long integer is a good one. Will a text type of 10 characters work okay? Thanks. |
#2
|
|||
|
|||
Linking tables
All field types are valid for linked tables. Long Integer and Text are
probably the most common field types in general (though 10 is too short for many things.) There seems to be an underlying question here? Perhaps you are trying to link across a Wide Area Network (WAN) rather than a wired LAN? If so, this might help: http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Warren" wrote in message ... Which datatype is best to use for the fields used in linking tables? I know Long integer is a good one. Will a text type of 10 characters work okay? Thanks. |
#3
|
|||
|
|||
Linking tables
On Wed, 25 Jun 2008 14:46:01 -0700, Warren
wrote: Which datatype is best to use for the fields used in linking tables? I know Long integer is a good one. Will a text type of 10 characters work okay? Thanks. Any field type except Memo and OLE Object will work. Large text fields can cause indexes to be larger than need be, and may impact performance; but I've got several applications with 8-12 byte Text primary/foreign keys, and they work just fine. I'd probably avoid using Float, Double, or Date/TIme fields as keys, inasmuch as they are subject to roundoff error. You might have a primary key value 3.1416 and a foreign key value that LOOKS like 3.1416 but is actually 3.14159999999997 and woulnd't link. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|