Linking columns

[umdengineeringstudent]

I need to link two columns together from different tables. the columns do not have the same name and also different data. But I need the column named Urgency in tblHISTORY to tell Column Open_Work_Order in tblSign to be yes only if SignID is in both tables and Column Urgency is High,Medium,or Low. But say no if column Urgency say Completed. Is this Possible? If so how do you do it.



Thanks

[June7]

What is table relationship? Is SignID a PK/FK? Build a query that joins these tables on PK/FK fields. Construct a field in the query that does calculation for the Yes/No output. There is no need for the Urgency field in table - this Yes/No output can be calculated when needed.

[umdengineeringstudent]

what is PK/FK

[June7]

Primary Key / Foreign Key

[umdengineeringstudent]

the only relationship is the signID. SignID is a unique number assigned by me. it is not a pk/fk in either table.

[June7]

Your info is contradictory.

You said the calculation is dependent on whether SignID is found in other table. This implies a relationship that uses the SignID as a key link.

If SignID is not a key value then the tables have no relationship and why would it matter if same SignID value is in other table?

[umdengineeringstudent]

It is a key link now. But wasn't in the past. in the past the two tables didn't share the information. The sign ID was inserted into them by the user. so they have the same ID in them. in the case of tblHISTORY the sign id may be used multiple times.

[June7]

Then it should be designated a primary key in tblSign. Now build query.

[umdengineeringstudent]

I tried setting it as the primary key and this error comes up

[June7]

Then SignID is not unique in tblSign. There are duplicate values. Your data is messed up.

[umdengineeringstudent]

there is a query that forms a relationship between the two that I over looked. Is there anyway of doing what I am looking for with this query?

[June7]

Not unless you fix the data in tblSign so SignID is unique.

[umdengineeringstudent]

Okay, so once I fix it and make the all unique. what is the process?

[June7]

Set the SignID field as primary key.

See post 2 - build query, do calc in query. This is basic Access functionality. https://support.office.com/en-ca/art...4-5ee8e1c29dc7