Search options (Page 3 of 3)

Say I have two Truck (vehicles). Truck 1 and Truck 2 and they both have their own inventory that they take to the job site.
Well, I want to keep inventory for each truck on my database.

When I made my project I clicked on Truck 1 and you can see and add inventory.
The moment you go to Truck 2 you end up seeing a mirror image of Truck 1 Inventory.

Each Truck has it's own inventory and I would like to keep them separated.

I got some sleep, drank lots of coffee and went at it again with this database. By the way it's kicking my but!!
I had to "KISS" like Tcoton explained. LOL well it's working for me...
which includes 15 forms and managed to get it down to 5 tables. LOL
what a difference.

I'll keep you posted if I managed to work it out. :-D

Eddie

I wanted to keep each truck with it's own inventory. I didn't know how to go about it any other way.  I was making these decision around 2 am. I can't think clearly during the day, just imagine at Two O Clock in the morning.

See if I have this right...
To connect the Truck tables in series?

is this correct?

Hello Tcoton,

I added another picture to explain a little further in depth.
Sorry for the confusion...

In this project I have a form with a trucks information example(truck no., year, vehicle, license, and VIN)
Also all the inventory it carries through his jobs.

Looking at Image 4.jpg:
I have three images numbered as 1, 2, 3.

Starting from number 2.
I added two made up trucks not sure if they exist. :-)
when I save it.

I end up with #3 image.
The combobox must be selected individually
The Vehicles information is not visible after saving it. You must select the vehicle again by each individual combobox.

I would like for each combobox to retain its perspective information for the truck I selected.
I would also like to have the comboboxes automated. Example If I choose the Trucks License No. then, I would like
for this information to present itself automatically on combobox.

Thank you,
Eddie

Hello JB,

I'm making an inventory form for 4 vehicles and want to keep the inventory database separated. Since
the vehicles carry different types of equipment.

for example:

At the top of the image I typed in the trucks information.
I would like for that to stay in the cells  and be visible.

The inventory will be going to the Table grid as normal.

Thank you,
Eddie

JB,

It worked finally after 50 tries of trial and error. :-)
There was an error on my part. fixed.

Did as you said and it works great!

Thank you,
Eddie

Just looked at  the files properties and it's 15.8 MB