Record split between screens is missing information

J

JudyHNM

I have a vendor table. I also have several forms. The first Vendor form
contains the vendor name, address, etc. The second vendor form contains
product information, and the third vendor form contains pricing information.
All the information from all three forms is stored in the same table.

I go in and add a vendor -- the information from the main vendor screen is
saved in the table, but the information from the other two tables is NOT
saved. I can go back and enter the information later (after exiting the form
and going back in) and it will be saved.

What am I doing wrong that it won't save the data when adding a new vendor?

Thanks, Judy
 
P

pietlinden

JudyHNM said:
I have a vendor table. I also have several forms. The first Vendor form
contains the vendor name, address, etc. The second vendor form contains
product information, and the third vendor form contains pricing information.
All the information from all three forms is stored in the same table.

I go in and add a vendor -- the information from the main vendor screen is
saved in the table, but the information from the other two tables is NOT
saved. I can go back and enter the information later (after exiting the form
and going back in) and it will be saved.

What am I doing wrong that it won't save the data when adding a new vendor?

Thanks, Judy
Click to expand...

They're all in the _same_ table? Why?
Vendor ---sells---Products---with---PricingStructures

Vendor--(1,M)---Product----(1,M)---Pricing Structure.
That's 3 tables. Why do you have all this in one?

Vendor(VendorID (Primary Key),...)
Product(ProductID, SoldByVendorID (FK references Vendor.VendorID)
PricingStructure(StructureID,PSProductID (FK references
Product.ProductID)

Then you have
main form: Vendor
subform inside Vendor form: Product
subform inside Product form: Pricing Structure

Have a look at NWind. Note the
Customers--Invoices---InvoiceDetails---Products---Suppliers hierarchy.
Note how each item has it's own form (some with subforms).
 
Top