Set the value of a textbox based on the value of another textbox

[manoj9849967222]

HI

I have two tables with fields say Emp ID & Employee Name & the other one with Emp ID, Employee Name & Phone no. I have designed a form for the 2nd Table with fields Emp ID, Employee Name & Phone no.

I am trying that when i enter the Emp ID in the Form it should automatically display the Emp name which is present in the first table.

I have created a relation between the two tables. But still i am not able to do it.

Could you please suggest.

Regards
Manoj.

[JustJim]

HI

I have two tables with fields say Emp ID & Employee Name & the other one with Emp ID, Employee Name & Phone no. I have designed a form for the 2nd Table with fields Emp ID, Employee Name & Phone no.

I am trying that when i enter the Emp ID in the Form it should automatically display the Emp name which is present in the first table.

I have created a relation between the two tables. But still i am not able to do it.

Could you please suggest.

Regards
Manoj.

If one Employee can only have one name, one ID and one Phone No, then you only need one table. There is no need for another table unless one (for example) employee can have many (for example) Customers. This is when you need another table with linking relationships between them.

Let us know how you go.

Jim

[missinglinq]

I have two tables with fields say Emp ID & Employee Name & the other one with Emp ID, Employee Name & Phone no. I have designed a form for the 2nd Table with fields Emp ID, Employee Name & Phone no.

I agree with Jim! Given the above, it makes absolutely no sense to have two tables to hold this information. Having both EmpID and Employee Name in two tables violates The Cardinal Rule of relational databases; with the exception of Primary/Foreign keys, never store the same information in more than one table! You need to scrap the table that just contains the Emp ID & Employee Name and go with the one that contains Emp ID, Employee Name & Phone Number.

The easiest way to retrieve a given record, which is what you're trying to do, is to create a form (which you say yuo've already done) using this table or a query that includes this table as the Record Source.

Place a combo box (dropdown box) on the form
Ehrn the Combobox Wizard comes up:
Select "Find a record on my form based on the value I've selected..."
Next
Select the appropriate identifying field to appear in the Combo box (EmpID in your case)
Next
Size the Combo box column
Next
Name the combo box
Finish

Now the user can use the dropdown arrow of the combo box to retrieve the data or simply start typing the identifying data in and the combo box will start to autocomplete the entry. When the correct entry is found hit <Enter> and the appropriate data should be retrieved.

Good Luck!

Linq ;0)>

[manoj9849967222]

Thank you Missinglinq & Jim..

Its working. I was unnecessarly creating a 2nd table.

Thank you again.

I have two tables with fields say Emp ID & Employee Name & the other one with Emp ID, Employee Name & Phone no. I have designed a form for the 2nd Table with fields Emp ID, Employee Name & Phone no.

I agree with Jim! Given the above, it makes absolutely no sense to have two tables to hold this information. Having both EmpID and Employee Name in two tables violates The Cardinal Rule of relational databases; with the exception of Primary/Foreign keys, never store the same information in more than one table! You need to scrap the table that just contains the Emp ID & Employee Name and go with the one that contains Emp ID, Employee Name & Phone Number.

The easiest way to retrieve a given record, which is what you're trying to do, is to create a form (which you say yuo've already done) using this table or a query that includes this table as the Record Source.

Place a combo box (dropdown box) on the form
Ehrn the Combobox Wizard comes up:
Select "Find a record on my form based on the value I've selected..."
Next
Select the appropriate identifying field to appear in the Combo box (EmpID in your case)
Next
Size the Combo box column
Next
Name the combo box
Finish

Now the user can use the dropdown arrow of the combo box to retrieve the data or simply start typing the identifying data in and the combo box will start to autocomplete the entry. When the correct entry is found hit <Enter> and the appropriate data should be retrieved.

Good Luck!

Linq ;0)>

[missinglinq]

Yes you were! Life, including Access, is complicated enough! No need to make it more so!

Glad you got it figured out! Let us know if we can help further!

Linq ;0)>