Two Forms from One Table that Affect Each Other

[jaypee1122]

Hi there,

I am quite new to Access and have probably some idea of it.

anyway I am trying to make a database that will help with our inventory. So basically I have a table for a certain item and I wanted to make a form that is used for booking in the item.

then make another form to book those available items out to a customer.

At the moment I have made the forms in a way that it has all the information required for booking in and booking out. Booking in form seems to work. but the booking out form doesn't seem to work the way I want it to.

I currently have the form to do a combo list to find a batch number that is unique to the item when booking in. but when entering other details such as where the item is going to, it just end up adding the new record to another line in the table.

Hope this makes sense.

thanks

[twinnyfo]

jaypee1122,

Welcome to Bytes!

Are your "Booking In" and "Booking Out" items all from the same table and all related to the same record? If so, just include the Booking In and Booking Out items on the same form.

I don't know the structure of your DB, either, so I can't address other issues of normalization and such--but just based off your brief description, this seems to be what is happening, unless I don't understand your table correctly.

[zmbd]

jaypee1122
- Have you looked at the inventory/billing Access templates that are floating around the internet?
- Are you familiar with the term Database Normalization - it can be (and usually is) your friend. Proper normalization and table layout in the beginning will minimize the issues you will run into - especially with a inventory/invoicing database
home > topics > microsoft access / vba > insights > database normalization and table structures
- Without your database layout, at least a list of the tables and how they relate to each other, it's near impossible to go much further.