Data entry form question

[DaverD]

Can anyone give me insight into how to do the following?...

I have a membership database and on the Members record, I want to pull the dues from another source based on the results of one condition that will have one of two results.

The amount of the dues is based on whether it is a "Single" or "Dual" membership. This field is on the Members form and in the Members table.

In addition, as time goes by and the initial dues are changed, I want to keep track of the different due schedules and who is under which schedule.

I am seeing having two separate dues tables. In the Members form, I will have a combo box looking for either Single or Dual membership type. Once set, the dues field is pointed to the appropriate table (SingleDues or DualDues) and pull up the "current" dues.

Questions I ask include:
1) Is it better to store the single and dual dues in one table?

2) Regardless if it is one table or two, if I am storing current and past dues for both Single and Dual memberships, how do I identify the "currrent" dues for either and how do I have the Member form pull up the value? DLookup?

Thanks in advance for your help.

 

[MajP]

First I would repost this in the "Tables and Relationship " forum. You are worrying about the input, but you do not even have a proper table structure yet. This is really a tables question. Once you get the right database structure, we can help you make a form to do whatever you want. If your structure is not right, then it is like fitting a round peg in a square hole. When you repost describe your applicable tables. Include table names, primary keys, foriegn keys, other relevant fields, and relationship type. Then describe what you want to do using general "buisness rules" not how you think the form should work.