Data for forms

Hi Colin

I'll do my best to answer your questions

1) There does not appear to be a primary key set in either of the tables. I can't see it in the design view, but can see it in the relationships?>

There needs to be a primary key for the Branchcode field in the Branches table. I've resent my example again in case it wasn't set.

2) How do you set the dropdown table? and how do you get it to auto select the other data? In the design view of the branches table, there does not appear to be a setting in the field properties that stands out.

The combo box field is in the SalesInfo table on the Branch field.
To create the SalesInfo form use Create, More Forms, Form Wizard.
Choose the Branch field from the SalesInfo table
Choose the BranchName, Address, Manger from the Branches table. I added two more fields Date and Sales from the SalesIndo table to create some context.

3) How do you launch a new form each time you want to input data? I.e. you will have to submit a new form each month?

Click the new record button (>*) at the bottom on the navigation buttons to enter new blank record each month. Or add a form control command button onto your form to do the same. (In Form Design view the one marked xxxx. I've added an 'add new record' button on my example).

4) I had set some relationships, 1 is to many (in my example) but had to undo as I had not set up my data correctly. If I set relationships, will this allow me to avoid using the primary key?

Unfortunately there has to be a primary key in the Branches table for the form to update.

I thought I was getting somewhere, but have to go back to the beginning to move forward again!

Good to ask questions like you are doing!

Doug