M
Mercadogs
Hello Community:
I have a parts database. The data consists of fields such as "Item Name",
"Vendor Name", etc... These fields could contain repetitious information. For
example, there could be 500 items with Item Name "Valve". Therefore, I
created tables for most of these fields and linked them all back to a Main
Table through One-to-Many relationship. The Main table contains foriegn keys
that are primary keys (autonumber) to the related tables.
I created a form with multiple record sources, to be able to update and
create records in the Main table. The updating seems to work. I enter info
into the form, and autonumbers are generated into the related tables as
primary keys for the new data, also those autonumbers automatically generate
as foreign keys in the main table.
However, when I create a new record, the form allows me to input information
into the fields for all the other tables except the Main table.
Could someone help me figure this out?!! I don't understand. All fields can
be updated successfully through this form, but when it comes to adding new
record, the fields for the Main table don't allow me to enter anything!
If I can clarify my question further, please let me know.
Thank you for your help!!
--Mercado
I have a parts database. The data consists of fields such as "Item Name",
"Vendor Name", etc... These fields could contain repetitious information. For
example, there could be 500 items with Item Name "Valve". Therefore, I
created tables for most of these fields and linked them all back to a Main
Table through One-to-Many relationship. The Main table contains foriegn keys
that are primary keys (autonumber) to the related tables.
I created a form with multiple record sources, to be able to update and
create records in the Main table. The updating seems to work. I enter info
into the form, and autonumbers are generated into the related tables as
primary keys for the new data, also those autonumbers automatically generate
as foreign keys in the main table.
However, when I create a new record, the form allows me to input information
into the fields for all the other tables except the Main table.
Could someone help me figure this out?!! I don't understand. All fields can
be updated successfully through this form, but when it comes to adding new
record, the fields for the Main table don't allow me to enter anything!
If I can clarify my question further, please let me know.
Thank you for your help!!
--Mercado