2 Questions - Related Fields and Table Population

[KC]

I appologize if this is not the correct forum. I have 2 issues with a database I am setting up.

1st Issue: While using a form to popluate the table, my data appears in the form correctly. However, when I return to the table to check the data, the information is missing in some fields. What causes this, and how can I remedy the issue

2nd Issue: I have 2 tables which are linked. The first table contains logistical data around my vendors. The second table contains data listing the services the vendor offers. The tables are linked through a common field. However, when I use the forms to update the services a vendor provides I get the message: "You cannot add or change a record because a related record is required in the table "[first table]"

Can anyone help?

 

[Allen Browne]

The simplest solution might be to use a form with a subform.

The main form is bound to your main table.
The subform is bound to the related table.
You can enter or select a record in the main form, and the subform shows the
related records (typically one per row).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I appologize if this is not the correct forum. I have 2 issues with a database I am setting up.

1st Issue: While using a form to popluate the table, my data appears in

the form correctly. However, when I return to the table to check the data,
the information is missing in some fields. What causes this, and how can I
remedy the issue?

2nd Issue: I have 2 tables which are linked. The first table contains

logistical data around my vendors. The second table contains data listing
the services the vendor offers. The tables are linked through a common
field. However, when I use the forms to update the services a vendor
provides I get the message: "You cannot add or change a record because a
related record is required in the table "[first table]".