Hi,
I have a Facilities Table with a one-many relationship with a Rooms Table.
The Rooms Table has the following fields;
Related Facility (Numeric) which is related to the Facilities Table.
Facility Name (Text) which is a Lookup Proxy.
Room No. (Numeric).
Facility_Room No Validation (Formula Numeric).
Facility_Room No Validation has the formula ToNumber([Related Facility]&[Room No.])
If Related Facility is 1 and Room No 333 it returns a value of 1333, as per below.
------------------------------
Tim Egerton
------------------------------