ACCESS: Table Field equal another Field in the Same table

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,720
I have a list of Fields that MUST be in a Table. The data from this table is uploaded into another program. The Criteria for one of the fields is that it equals another field in the same table. Yes, I know repetitious. I am trying to figure out the best way to handle this situation. Can I make the default value in this field equal another field in the same table?? is there a formula I can put in the Default? Or do I need to handle this on the form with an Event? I would rather have a default value on the form if at all possible.

Thanks!
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,103
Office Version
365
Platform
Windows
If you have two fields in the same Table that MUST be equal to each other, what is the purpose of having two fields, instead of just that one?
Setting up fields in a table that are dependent upon other fields in the same table violates the rules of Data Normalization, and could cause database integrity issues and undermine data integrity.

Can you explain why you need two fields that hold the same value, instead of just having one field?
If we understand why you are trying to do this, we may be able to make suggestions.
 

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,720
Joe;

I am using Access to create a form that makes it easier for the user to enter data. The data is going to be uploaded to another program (Deltek CostPoint). The GUI that Deltek has is horrible. Its in Excel and the data gets entered in several different tabs. Plus I have an issue of Multiple users - which Excel is not the best at handling. Therefore I am trying to make a better GUI using Access. Why Deltek has two fields that have the same data - I don't know. All I know is that my form has to have all the same fields that the Deltek GIU has. Several of their fields have a default value of another field. Why? I have no idea and way to find out why.

I am not using Access necessarily to store the data - its being used as GIU. I assume from your answer that the best way to handle this is on a form where the user will enter the data. I can create an event in that populates the "Duplicate" field when the first filed is changed/updated. I know it doesn't make sense to have the same data in two fields, but my task is
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,103
Office Version
365
Platform
Windows
So, are you exporting the data to Deltek, and that requires two fields with the same value?
If so, there is no need to have the same field twice in your Table, you can add the same Table field twice in your Query (and use the Query for your export).
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,103
Office Version
365
Platform
Windows
You are welcome!
:)
 

Watch MrExcel Video

Forum statistics

Threads
1,096,409
Messages
5,450,259
Members
405,600
Latest member
capcomdevil

This Week's Hot Topics

Top