tblOrg has these fields
OrgID PK
OrgNo Text
OrgDescr Text
I would like to see the OrgNo get displayed in two other tables: tblExpense and tblRevenue from a drop down list on the forms that are based on these two tables, ie., tblExpese & tblRevenue
To include OrgID as one of the fields in these two tables, I first selected the data type to be a Number. When I tried to enter data, I get the error message that reads:
“The value you entered is not valid for this field. For example, you must have entered text in a numeric field…”
Of course I did.
What is the solution? Can somebody please help? Many thanks.