G Guest Dec 7, 2004 #1 I need to set up monthly pymts sent in from family members for a family reunion. How and where would I do this
I need to set up monthly pymts sent in from family members for a family reunion. How and where would I do this
J John Vinson Dec 7, 2004 #2 On Mon, 6 Dec 2004 19:29:03 -0800, "new at this" <new at I need to set up monthly pymts sent in from family members for a family reunion. How and where would I do this Click to expand... It sounds like you should have two tables: People PersonID LastName FirstName <other bio information, address, phone, etc> Payments PersonID <<< who made the payment PaymentDate Date/Time Amount Currency <any other fields needed about individual payments> You can enter data into these tables by creating a Form based on People, with a Subform based on Payments. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps
On Mon, 6 Dec 2004 19:29:03 -0800, "new at this" <new at I need to set up monthly pymts sent in from family members for a family reunion. How and where would I do this Click to expand... It sounds like you should have two tables: People PersonID LastName FirstName <other bio information, address, phone, etc> Payments PersonID <<< who made the payment PaymentDate Date/Time Amount Currency <any other fields needed about individual payments> You can enter data into these tables by creating a Form based on People, with a Subform based on Payments. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps
