Subforms trouble

[-=fREaKy=-]

My subform is going wonky.

I am doing an ordering system for a project.

The main form contains the customers details and it's subform contains the order(s).

The whole form is based on a query which is based on two tables.

When I want to add another order for the same customer, it creates an extra record in the main table, without the customers details (it just puts in the product)

Sometimes it will appear to save the order for the same customer but when i close Access then open it, the *new* order will appear in a new subform record but without customer details!

Please please please help me out on this.

I have only once used subforms before, whilst going through a book.

I need to get this fixed and appreciate the help - thanx a lot

 

[Susilowati]

Hi there
This sounds really strange. Have you checked your relationships between the customer and order table?
Unfortunately I have not got enough information from your explanation. I believe this is just a simple bug that everyone always encounters every now and then.
If you wish me to have a look at your database, just attach it here, and I'll have a look later.
cheers SS

 

[-=fREaKy=-]

Thanx for your help SS - how do i attach it?

 

[Rich]

You can't attach here, you'll have to send it

 

[-=fREaKy=-]

thought so

- thanx