423,688 Members | 1,889 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,688 IT Pros & Developers. It's quick & easy.

Two Forms from One Table that Affect Each Other

P: 1
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
Aug 29 '18 #1
Share this Question
Share on Google+
2 Replies


twinnyfo
Expert Mod 2.5K+
P: 2,667
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.
Aug 29 '18 #2

zmbd
Expert Mod 5K+
P: 5,285
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.
Aug 31 '18 #3

Post your reply

Sign in to post your reply or Sign up for a free account.