referencing a duplicate id in separate table

[madman411]

Hi all

 

I have two tables - Table A and Table B. 

 

Table A contains all of our company's inventory. Each inventory item has a barcode number "barcodeid". Not all of the database users have permissions to add new inventory items, and sometimes certain items get overlooked. As a result, I've created a new table where our general users can request an add to the inventory system (Table B ).

 

On the admin side, I have a table (Table B ) view that displays the requested items. One thing the user is required to enter is the barcode id that is on the item that is missing from the system (the barcode id is generated using separate software - the way this was incorporated was out of my hands). I would like the barcode id to appear in green should the barcode id NOT match an existing barcode id in Table A.

 

I know this would be relatively simple conditional formatting, but I'm failing to see how I would create the relationship between the barcode ID in Table A and Table B. Eventually I plan on using this relationship to just prompt the end user that the record exists, but for now I just want the admin user to have this function.

 

Any help appreciated.

[comment]

'm failing to see how I would create the relationship between the barcode ID in Table A and Table B.

 

Exactly like you just said: link the two tables, matching on the Barcode field:

Inventory::Barcode = Requests::Barcode

(please note the absence of abstract names; humans present)

 

 

Once you have that in place, you can apply conditional formatting to the Barcode field on the Requests layout and make it green when =

IsEmpty ( Inventory::Barcode )

[madman411]

Thanks comment. Totally over complicated this in my head.