munkeyroot
Registered User.
- Local time
- Today, 16:09
- Joined
- Jan 13, 2011
- Messages
- 76
Hi all
hope you can help i have created a few form databases but am a bit stuck on this one
i am designing a booking in booking out system
quick layout of what i like to acheive
booking in
a load comes in and an open weighbridge ticket gets created via another programme and given a ticket number.
load gets booked in a access booking in form and items are given a separate unique barcode which then gets scanned in the booking in form against the open weighbridge number.
booking out
an new open weighbridge ticket is generated with ticket number via another programme.
items to be booked out are barcode scanned and added to a list against the opened weighbridge ticket.
when booking out process is complete, the booked out access list gets printed and signed off by the weighbridge and driver.
quiery on how to achiecve this.
would it be a case of playing around with the relationships? if so which way would be best?
would the booking out list be better on access geneated speadsheet or could this be done in anotherway?
as you can see i am a little lost haha
again hope you can help
cheers matt
hope you can help i have created a few form databases but am a bit stuck on this one
i am designing a booking in booking out system
quick layout of what i like to acheive
booking in
a load comes in and an open weighbridge ticket gets created via another programme and given a ticket number.
load gets booked in a access booking in form and items are given a separate unique barcode which then gets scanned in the booking in form against the open weighbridge number.
booking out
an new open weighbridge ticket is generated with ticket number via another programme.
items to be booked out are barcode scanned and added to a list against the opened weighbridge ticket.
when booking out process is complete, the booked out access list gets printed and signed off by the weighbridge and driver.
quiery on how to achiecve this.
would it be a case of playing around with the relationships? if so which way would be best?
would the booking out list be better on access geneated speadsheet or could this be done in anotherway?
as you can see i am a little lost haha
again hope you can help
cheers matt