A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"linked tables:" recommendations



 
 
Thread Tools Display Modes
  #1  
Old July 7th, 2005, 03:39 PM
PaulFort
external usenet poster
 
Posts: n/a
Default "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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 07:29 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.