Cronk,
1. I seems the problem was generated by longer text field size in tAssets than in linked tables. The minute the field in tAssets was longer than text fields size than the linked tables the problem surfaced. I have made sure text field size were the same for linked fields.
2. "Is there any reason you use the name of assets as the primary key? It would be normal practice that an Asset table would have AssetID autonumber primary key and Asset name text."
The unique asset ID is text in other database and records. It has been suggested that I make the database primary key of tAsset Autonumber. This would of course mean I would have to change all linked foreign key to number and would have to create a new field in tAssets for the unique text ID. What do you suggest?
3. As I work to begin cleanup, I noticed that my numbered tables (01 through 13) do not all have the same relationship with the tAssets.PS_ID. In tables 06 through 13 it is "one to one" while in tables 01 and 04 it is the expected "one to many". I show this in attatched Zip (
20131123_01.pdf). I have also attached the updated database. Note: I am presently only working on Forms and Relationships. Other portions of this structure are just their.
You help is greatly appreciated.
Timothy