One Form - Multiple Tables

[ddkolb42]

Has anyone ever seen a sample database that can be downloaded to demonstrate how develop relationships that will accommodate a single form serving multiple tables please?

[burrina]

In order to develop your relationships, many questions have to answered first.
1. What is the purpose of the database?
2. What do you want to happen and when.
etc...

Of course a form(s) can use many tables as it's record source but it depends.

You need to explain your concept for us to offer assistance.

EDIT: OKay, poor choice of words. You CAN use more than 1 table for your form! Meaning like a Comb box , etc...
But ONLY 1 table for it's record source.

[June7]

Ordinarily, a form can enter/edit data for only 1 table. Use form/subform arrangement to interact with multiple tables.

However, if tables are 1-to-1 relationship then existing records in multiple tables can be joined in a query and they can be edited. I have a database with this arrangement. Creating related records in the multiple tables cannot be done by form bound to a query that includes the multiple tables. I accomplish creating the records with minimal data using VBA code. Then a composite form is opened for users to complete data entry.

[ddkolb]

I am creating a database that will allow the user to apply a record in one of three separate table. Vendor1 table, vendor2 table, and vendor3 table. these vendors dispense product from vending machines. We want to eliminate the use of recording hand written refunds due to vending machines not providing product and keep money. Since the business expect us to refund the customer, they, in turn refund us. I want to be able to use on form that will feed a report that will act as a receipt for for the vendor when he reimburses us. I hope that is understandable

I started this with one table and one form. However I need to have the capability to provide EACH vendor with a receipt. When they replenish the petty cash for refunding I need to keep separate tallies for each vendor. I have three tables that I have populated for testing purposes.

[June7]

Should not have 3 tables. Should be 1 table with another field for VendorID.

Apply filter to form by VendorID.

[ddkolb]

Thank you so much, I will try that.