Autonumber in multitable form

[Fairlane]

I [noob] have created a DB for tracking assets but when I built it I did not have it normalized and am now trying to normalize it.
AssetTable has
[Key(autonumber)],[serial(text)],[PN(text)],[measure1(text)],[measure2(text)]

I am planning to normalize using key field in many tables combined in forms

SerialTable contains [key],[serial],[PN]

MeasureTable has [Key(number)],[measure1],[measure2]



I want to create a form where user can enter serial, PN, measure1, and measure2 at once. As soon as I add fields from MeasureTable autonumber on SerialTable.Key does not work (creates null record in field).

Any ideas. If I can clarify anything let me know. TIA

[amrut]

How and which fields in these three tables related to each other ? Table relationships require the fields to be of same type.
Here is a guide to it http://office.microsoft.com/en-001/a...010120534.aspx

[Fairlane]

SerialTable.Key and MeasureTable.Key relate to each other. record SerialTable.Key 14237 (created using Autonumber)would specify the serial number and part number of the asset while MeasureTable.Key 14237 (created via "Default Value" in the form) would specify the desired measurements.

This way a report would show a serial, PN, and measurements, for a group of assets without having a table with 20 columns in it or omitting assets without any measurements which happens when I manually create measurement records for only the assets that get measured

[amrut]

Can you post a screenshot of your table relationships ? What about the AssetTable ?

record SerialTable.Key 14237 (created using Autonumber)would specify the serial number and part number of the asset while MeasureTable.Key 14237

From above it looks SerialTable is the Master Table and MeasureTable is the child one.

As soon as I add fields from MeasureTable autonumber on SerialTable.Key does not work (creates null record in field).

In which table a null record is created ? How do you enter data in SerialTable ?

[Fairlane]

I seem to have fixed the issue by starting the DB from scratch. The autonumber worked for SerialTable.Key while putting " " as the default value for measure1 kick-started the MeasureTable.key default = SerialTable.Key action.

AssetTable is the old unnormalized table that had 20 columns in it.

[maxmaggot]

Can we have a look at a screenshot of your relationships or upload the db to something like box.com and share the link. You can remove private data from a copy of the orinial.That would greatly sppeed up the process