If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"linked tables:" recommendations
I'm new to Access (Using Access 2003) and would appreciate recommendations on
the method to use to do the following. (..the cleanest, most effecient way to do this.) My users will be importing a new csv table weekly. This table will include records with the clients names and soc sec numbers. My users will add information to each client. This information (fields) is not included in the original imported table. These fields include clients' birthdates, phone numbers etc. This part I have done. (They import into a table alread in the db that includes these xtra fields.) Now I need to allow users to add, with a form, a list of multiple items to each client: They will be keeping track of the client's attendance on a daily basis. So this seems like it should be a seperate table assigned to each client. I don't know in advance how many clients will be included in that imported csv table so these 'linked tables' have to be created automatically. It will look like this: User finds the client with a form, sees how many days he has attended this week and can add today's date to that client's list. How best to do this? Thanks much. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copying tables from a linked database in to a new database | David Paterson | General Discussion | 2 | May 13th, 2005 04:50 PM |
Read-only Linked Tables | AH | Running & Setting Up Queries | 0 | May 13th, 2005 01:51 PM |
why cant I see the any tables in the linked table manager | BG | General Discussion | 1 | April 25th, 2005 05:44 PM |
Mechanism - relink linked tables within a client automatically - Access 97 - whe | ImraneA | New Users | 1 | March 15th, 2005 09:48 AM |
FileAs field in Outlook 2K3 - Access Linked Tables | Jeff Briar-Hill | Contacts | 1 | October 23rd, 2004 08:28 PM |