Hello,
I am building a database at the moment to pick up orders for a pizzeria. I made the following tables:
Order:
id
customer_id
date
total_price
Billing:
id
order_id
menu_id
number
Menu:
id
name
summary
price
I made a form in Access 2010 with an subform in it to pickup the order. But the problem is whenever I make an order it doesn't give me an Order.id at the start, so it wont be filled in at Billing.id when someone is taking the order. If I fill in manually something in Order.id it does work and the id is also saved at Billing.id when taking the order.
Autonumber doesn't seem to work for me because I don't want any user interaction to finally get an unique id, it needs to be filled in when the form is opened. I searched now on the internet for a while and i've read something about Dmax. But I didn't get it working in a textbox or number field.
I need some help! Thanks.
I use Access 2010, English, 64 Bits.