I need advice - do a I use unbound forms?

[Tiny bird]

I have an Access 97 project - a split database that will soon link into SQL back end.

I have 2 tables of customers - tblMembers (2 types of customer) and tblNonMembers (1 type of customer)

When creating forms for promotions I find myself creating replica forms for the 3 types of customers with practically the same form layout except for a subform. Therefore I change the Select statement in the Data Source to filter off their records i.e. tblMember CustomerType1, tblMember CustomerType2 and tblNonMembers all records

Am I doing this wrong? Surely there must be a more effective way of doing these forms. I have heard of unbound forms but have never played with them before.

My database is getting huge!

Any help or suggestions would be greatly appreciated.

 

[Rich]

Why can't you just have one table with the Membership defined

 

[jwindon]

I know what you are after here, but I urge you to first take Rich's advice and look at your table structure first.

What you can do later then is to use a filter to open the form to ONLY those customer types you want. You will have to add code to toggle visibility a bit to have the view just the way it needs to be seen for each customer type data entry.

The way it is heading now....you will end up creating replica reports, etc in the end and your db will grow even more.

 

[Tiny bird]

Thanks for your comments and advice.

I agree totally on joining the 2 tables. They were originally as 1 but we had to split them as the majority were non members 30,000 + and the database speed was being greatly affected. Believe it or not a computer consultancy specialising in Access advised us to do this in our early learning stages!

I will be joining the tables once we are migrate to SQL (in the next month). But unfortunatley in the meantime I the new working forms today!

Thanks anyway

Sara