One table many forms

[TimjHebert]

I am setting up a database with one table and 4 forms. This database will be a multi user database. I would like to know the best way to generate an incrementing rental number. How can i set it up so users dont access the rental number at the same time?

Thanks,
Tim

 

[Fizzio]

Let Access take care of that by using an autonumber as your ID in your main table. You can then format it how you want to on the form.

 

[ColinEssex]

Why would you need 4 forms for one table? also, its best to use a query and not the table direct.

What fields have you got in the table?

Col

 

[TimjHebert]

one table many forms

We rent radio equipment to petroleum companies. all i need is a single table, but i want to use a form for boats, one for the shorebase and one for the rig. there will be more than one user for the database. i will call the table (rent) and the create the forms from it

 

[ColinEssex]

so one company can rent many pieces of equipment?

 

[TimjHebert]

one tabel many forms

Yes, one company can rent several pieces of equipment. Any help would be greatly appreciated.

Thanks,
Tim

 

[ColinEssex]

Yes, one company can rent several pieces of equipment.

Then you'll need 2 tables at least. One for the Company and one for the rentals.

As Fizzio said, use an AutoNumber as a unique identifier in the Company table, make that a Primary Key and have the same field (but as a number) in the Rentals table as the Foreign Key, then you can link the 2 together in the relationships. Then you can have a SubForm on the Company form to show their rental history and what they currently have on rental.

If you stick with the one table scenario, you have to enter the Company details more than once and it'll make it extrememly hard to identify who has had what rentals later on.

Then you need to create "masterfile" table of the rental stuff and use that in a ComboBox on the Rental form and you'll need a masterfile table for the "boat","Rig" and "Shore" identifiers, also for use in a ComboBox.

You need only one form for the Company and one form for the Rental data.

Col