Search results
-
K
Create a table for each record in another table
I think I have it unless you suggest doing your suggestion about: MemberNumber should be a field in Dues, but it should not be an autonumber nor the primary key. It should be just a regular number. This will hold the ID field value from Members. You should have an autonumber primary key in... -
K
Create a table for each record in another table
I finally got the table to populate. Here is the new one. I have 2 records in it, My Wife's and mine. -
K
Create a table for each record in another table
Well, I read that link and followed it and I read several other links and followed them. I have one hair left on my bald head and right now it is trembling in fear of getting pulled out. For the life of me I can't get the data from the Roster to the dues table. I have tried a query to... -
K
Create a table for each record in another table
Here it is. I deleted the records in it. I works to the point of putting in the payments. If you need, I can put in a couple od fictitious records. -
K
Create a table for each record in another table
Thanks, I'll try again. I must be reading that article wrong. I can't get it to work. -
K
Create a table for each record in another table
Can I use the auto numbered key as the unique key for the payment table? -
K
Create a table for each record in another table
I am trying to create an access 2007 database for Windows 7 that tracks payment dates for club members. I need a record for each date that the member paid. Each member has a separate record in a table called Roster. I want to take three fields from roster and put them in an individual table for...