First Record Value ID Calc

Thank you for your interest!..

I'm looking to Tie/relate record ONE in Associates table to

Project table as the "Company" Associate globaly to share with all Project records.

Example:

TableOneAssociates Fields:

- mp_id_tableone (autoenter SS# T1001)

- txt_assoc_name (just a text field)

TableTwoProjects Fields:

- glb_clc_tableone_first (global storage calculation field with result of (=TableOneAssociates: mp_id_tableone)[FirstRecordValue]))

Associates can be many and work on Projects. One Associates can own multiple Projects. Associates have check box tag of "Company", "Vendor", or "Client".

Associates can be one of these values or all of the above, except for value of "Company". Record ONE of Associates table will permanently be tagged as "Company".

Projects can be many and "owned" ONLY by "Company" record ONE in Associates table. Many Associates may "work" on projects as "Vendors" and done for as "Clients".

Each Company, Vendor, and Client will have it's own relation to Project table.

Does anyone have a calc that and produce result of record value one ss#ID?

Or maybe a better solution to this issue.

Thank you for any help!