UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Multiple forms to one table    
 
   
geee112
post May 31 2007, 09:06 AM
Post #1

New Member
Posts: 7
I am trying to create a from for each of my co-workers which will input data into one table. The forms are the same layout. I want the forms to be unique, meaning each person only views there own information. Is this possible, and if so how can I do it?
Go to the top of the page
 
+
MattJ
post May 31 2007, 09:10 AM
Post #2

UtterAccess VIP
Posts: 4,621
From: North Carolina, USA
Welcome to UA!
You should only have a single form that is used for all users, and restrict the information displayed based on the current user.


HTH
Matt
Go to the top of the page
 
+
dashiellx2000
post May 31 2007, 09:14 AM
Post #3

UtterAccess VIP
Posts: 9,209
From: Maryland
Hello and Welcome to UA!!!

If the form's all have the exact same layout but you want them to only able to view their own data, you will need to assocaite each record in the database with the person. One of the easiest ways would be to add a field which will hold a user id or something that is unique to each user. You can use an API to Get Login name of the user on the network or create your own login procedure like this one from the code archive.

HTH.
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 11:21 AM