Entering data into my table from a form [closed]

asked 2016-06-16 13:47:07 +0100

Deep gravatar image

I am very new to Databases and have created a very simple 1.

In brief I have 3 tables: Employees Phone Numbers Devices

I want to be able to match the 3 together with rerecording information.

I would like to create a form where I will have a First Name and Last Name and based on these 2 bits of information it will know the key ID for that employee and enter it into a 4th table

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by Ratslinger
close date 2016-06-16 16:07:48.915045

Comments

Unfortunately your question is a bit too brief. It is always helpful to include KEY DETAIL in a question - Click here. "...able to match the 3 together with rerecording information" needs some clarification. How are the three existing tables related - Name, Employee ID, etc? First & last names are not unique. Have seen small companies with same names. Please edit your question with more information. Key ID? Unique? System generated?

Ratslinger gravatar imageRatslinger ( 2016-06-16 15:05:02 +0100 )edit

Closed - restated under this question

Ratslinger gravatar imageRatslinger ( 2016-06-16 16:07:33 +0100 )edit