By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Editing Table by using relations...

P: n/a
Imagine two tables. One is T_Tender, other T_Material
T_Tender fiels: TenderNo, TenderName
T_Material fields: MatrNo, TenderNo

There is relation across TenderNo between two tables. I would like to
simply show TenderName in the table T_Material, rather than TenderNo.
But access should use TenderNo for that entry.

I am finishing now. My target actually to enable the user to edit
TenderNo for T_Material table using a form. Instead of TenderNo,
TenderName should be visible there to make the user job easier.

Will be appreceated for any help.

Nov 20 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
use a combo box control in your form. use the following property settings
for the combo box, as

ControlSource: TenderNo
RowSourceType: Table/Query
RowSource: T_Tender
ColumnCount: 2
ColumnWidths: 0"; 1"
BoundColumn: 1
ListWidth: 1.25"

adjust the *second* number in the ColumnWidths, and adjust the ListWidth, as
needed, so that the full TenderName values show in the droplist.

recommend you read up on combo box controls, and their properties, in Access
Help, so you'll understand how they work.

hth
<sa*************@yahoo.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Imagine two tables. One is T_Tender, other T_Material
T_Tender fiels: TenderNo, TenderName
T_Material fields: MatrNo, TenderNo

There is relation across TenderNo between two tables. I would like to
simply show TenderName in the table T_Material, rather than TenderNo.
But access should use TenderNo for that entry.

I am finishing now. My target actually to enable the user to edit
TenderNo for T_Material table using a form. Instead of TenderNo,
TenderName should be visible there to make the user job easier.

Will be appreceated for any help.

Nov 20 '06 #2

P: n/a
It sounds like what you want is a combo box on the form, with its Row Source
being, "SELECT TenderNo, TenderName FROM T-Tender ORDER BY TenderName"

The number of rows would be 2, the bound column would be 1, and the first
width of the first column in the Column Width property would be set to 0
(0";2" for example).

The Control Source would be TenderNo in table T_Material.

--
Darryl Kerkeslager
<sa*************@yahoo.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Imagine two tables. One is T_Tender, other T_Material
T_Tender fiels: TenderNo, TenderName
T_Material fields: MatrNo, TenderNo

There is relation across TenderNo between two tables. I would like to
simply show TenderName in the table T_Material, rather than TenderNo.
But access should use TenderNo for that entry.

I am finishing now. My target actually to enable the user to edit
TenderNo for T_Material table using a form. Instead of TenderNo,
TenderName should be visible there to make the user job easier.

Will be appreceated for any help.

Nov 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.