ACCESS: Table Field equal another Field in the Same table

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,835
Office Version
  1. 365
Platform
  1. Windows
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

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,649
Office Version
  1. 365
Platform
  1. 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,835
Office Version
  1. 365
Platform
  1. Windows
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
56,649
Office Version
  1. 365
Platform
  1. 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
56,649
Office Version
  1. 365
Platform
  1. Windows
You are welcome!
:)
 

Watch MrExcel Video

Forum statistics

Threads
1,127,549
Messages
5,625,443
Members
416,106
Latest member
Geo0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top