Relational User Form on Access 2010?

[jammy1812]

Hi guys,
Need a bit of help with a user form I'm trying to make for a database.
I've attached the database file with my attempt at the file too.
Not sure why, but it doesn't seem to allow me to update any data.
I've attached a few screens of what my eventual form will look like (spread over two pages) but I was trying to test adding data before I started to make it look nice, but couldn't get that far.

Is my design possible? If not, any suggestions??

[Norie]

Have you checked the relationships between the tables?

For example between the Order_Details table and the Sales_Member you have a many-to-one relationship based on salesid.

I would have thought it would be the other way round and/or be a many-to-many relationship.

I think things like that might be what's stopping you entering data using the form.

Could be wrong though.

Perhaps it's more to do with the query that's behind the form?

Can you enter data using the tables?

If you can then you can test that query to see if it returns any records and/or lets you enter data.

[jammy1812]

Hey,
The way I figured it, it was:

A sales person can have many orders that they've authorised, but an order can only have one sales person.

That right?