design concept

[Jen0dorf]

Hi



just like to run a design plan past any helpful designers as I've found to my costthere are many many ways to do any task.

I am importing 90+ spread sheets into a database

the spread sheets are individual each one relating to a parish church

each church has three spreadsheets - birth marriage and death.

I see no reason for any linked tables as each sheet contains items specific to that church iebirth/death/marriage.

I thought I keep each spreadsheet in it's own table

The database design would have an opening form which used a combo box to allow the user to select the church, this would then opne another form which would contain another combo box which allowed the user to select birth, marriage, death.

From that combo box open another form listing the option to search by name or year and from there run a query on the table to display the results.

I'm planning to use a temporary variable to using the combo box value to open appropriate forms.

This will be an ongoing project as records are added all the time.

Is this a good broad design plan?

thanks

Ian

[pbaldy]

Personally I'd have the churches in one table, with a field to identify the church. Not sure if birth marriage and death should be separate tables either. Depends on what they hold I suppose.