Same Field Name Used in More Than 1 Table?

[wilderfan]

Can I use the same field name in more than one table? (Though possible, perhaps it's not advisable?)

For example, let's say that there are 2 tables in the db: one named Staff and the other named Client Contact

The Staff table lists employees, so the fields might include:
First Name
Last Name
Street Address
City
State
Zip Code

The Client Contact table would likely contain similar information (except that the info would relate to the client contact).

Would it be advisable to create unique field names (which would require more characters)?

Example of unique field names:
Staff Fname in the Staff table
Client Fname in the Client Contact table
etc.


(I also anticipate that I might have many "Date" fields in different tables; perhaps I need to come up with unique field names for all these date fields, as well).

 

[boblarson]

You can use the same field names in different tables. But, it may be to your benefit to have different names so it removes any ambiguity around them. Also, remember not to use Access Reserved Words or special characters (I'd also suggest no spaces) in your field and object names. It will make life a whole lot easier.

 

[David Eagar]

You CAN, but would advise not to. It eventually leads to confusion as to what data is being sourced from where. I usually try and have some clue in the field name where it comes from, so in this example would use CLastName (for Client data) and SLastName for Staff