Hi again, firstly I like to thank the people who helped me through a coursework i needed help on, you have been great! THANK-YOU
I trust u ppl
I am now in the second semester and it's a project type module.
I need some help before I continue.
On paper, I have done/drawn up some relationships of tables etc...
The database is based on a company who make and sell some items/products and they are planning to implement technology/electronic format of organising this stuff.
Now, I have made up these tables needed, on paper:
Customer Details
Product Details
Unpaid Orders
Customer Order History
Order form
now, I am a newbie so please, talk easy on me!
Right what I want to know is some information for the order form:
I have decided to put in a subform in the order form, this subform is for the customer details.
Lets say, IF we enter an exisiting customer number, how can I tell it to bring up the customer details eg:
If customer number 1234 was Joe Bloggs, it should pull up this info from the Customer Table:
Joe Bloggs
1234 high street
Bloggs Land
ABC 123
is it possible? If so, how??
OK, so if the user doesn't enter and existing customer number, a new record is created, great.
If the exisiting customer is entered, and the user enters an EXISITING PRODUCT NUMBER from the Product Table, how can I tell it to show up the details of that product on the Order form table from the product details table? And then, how does it save all that ? Does it save all the order information in it's own table?
Sorry if it sounds complicated, I need help ASAP. I am trying very hard here, more than the group anyway and I am the key role in this. I just need to clear these small things up first otherwise I am doomed and don't want that.
So please, help me and if u r, explain in nice easy steps
Thank-you
Sorry for posting this thread in the forms group too....i don't know which one the question should be asked, sorry for the inconvenience caused
I trust u ppl
I am now in the second semester and it's a project type module.
I need some help before I continue.
On paper, I have done/drawn up some relationships of tables etc...
The database is based on a company who make and sell some items/products and they are planning to implement technology/electronic format of organising this stuff.
Now, I have made up these tables needed, on paper:
Customer Details
Product Details
Unpaid Orders
Customer Order History
Order form
now, I am a newbie so please, talk easy on me!
Right what I want to know is some information for the order form:
I have decided to put in a subform in the order form, this subform is for the customer details.
Lets say, IF we enter an exisiting customer number, how can I tell it to bring up the customer details eg:
If customer number 1234 was Joe Bloggs, it should pull up this info from the Customer Table:
Joe Bloggs
1234 high street
Bloggs Land
ABC 123
is it possible? If so, how??
OK, so if the user doesn't enter and existing customer number, a new record is created, great.
If the exisiting customer is entered, and the user enters an EXISITING PRODUCT NUMBER from the Product Table, how can I tell it to show up the details of that product on the Order form table from the product details table? And then, how does it save all that ? Does it save all the order information in it's own table?
Sorry if it sounds complicated, I need help ASAP. I am trying very hard here, more than the group anyway and I am the key role in this. I just need to clear these small things up first otherwise I am doomed and don't want that.
So please, help me and if u r, explain in nice easy steps
Thank-you
Sorry for posting this thread in the forms group too....i don't know which one the question should be asked, sorry for the inconvenience caused
