Hello everyone,
please I have an urgent Project to develop. Can someone teach me how can I insert data in a related table with append query or another way. So here what I have:
tblCostumer :{ID, CostumerID, CostumerName}
tblCOrders:{ID, Date, OrderNote, Preis, CostumerID}
These tables are linked with CostumerID, that means each Costumer as its own folder with OrderNotes, Dates and Price.
What I need to do is that each time when I create a new costumer I want to be automatically inserted records in field Datum of tblCOrders from Date 01.01.2011 until 31.12.2011 that means 365 days. So than I can just put the notes directlly to the related date.
I have also a field named Prise. I want that in this field to be Inserted the value that I give in the textBox Preis which I have placed in my form.
Below you have my attachment
Is that possible?
I would be extremly thankfull if someone could help.