2. ASPRunnerPro General questions
  3. Update field in Master table
This topic is locked

Update field in Master table

 		6/9/2009 6:31:22 PM
ASPRunnerPro General questions
C
 crisstyd author

I believe I need to add an Action before record updated, but I cannot figure out the syntax. I have an EMPLOYEE table and a MANAGER table. This is how I have it set up:
MANAGER TABLE
Manager ID

Manager NAME
----->this table has a relationship to
EMPLOYEE TABLE
Employee ID

Employee NAME

PASSWORD (field is blank)
--------->So the output table looks like this and works fine (mangers can only see their unique employees)
Manager ID

Manager NAME

Employee ID

Employee NAME

PASSWORD (field is blank)
----------->What I need to do is....
When the manager logs in he sees all his employees and can update their passwords.
Where I am stuck.....The employee password needs to pass back to the EMPLOYEE TABLE so that when the employee logs in he will have a password. Otherwise, he cannot log in until his manager approves.
J
 		Jane 6/10/2009

Hi,
I'm not sure that I understand your question.

How are these tables linked? What table do you use as login table on the Security tab?
C
 		crisstyd author 6/10/2009

Jane...Thanks for your response, but I figured it out <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=41794&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
C
 		crisstyd author 6/11/2009

OK... got stuck again.
User selects (SIGNUP) page to sign up for dates:
ID (autonumbered)

Employee (prefilled from login)

EENAME (looked up from another table)

POSITION (looked up from another table)

Date (user fills in this information)
Everything works fine, when I go to the List Page it shows all the information. But.....when I try to access the information from a LOOKUP on another page it doesn't show.
Basically, after the form is filled is is not passing some of the information to the (SIGNUP) table. How can I get the data that is being LOOKED UP to insert into the SIGNUP table?
I inserted the following table event BEFORE RECORD ADDED
dal.signup.EENAME=EENAME

dal.signup.POSITION=POSITION

dal.signup.Add()

BeforeAdd = True
Fields are the same on the both tables
C
 		crisstyd author 6/11/2009

Figured it out again <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=41826&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' />
G
 		gloryforixseal 6/18/2009

Hey Fu,
Tried finding this on my own, but my search ended up the old needle in a haystack thing...
What is the SQL code to drop a table from your database, and what would it be to drop a specific field in a table?
Thanks,
Robert