Lookup

[Michelle]

I have a form that has two subforms it is for software.
The main form is based off the Software Table, 1 sub Form contains the
License Information for the Software (not problem with this one) the second
subform has System Assignment(s) "ie the system tag that is assigned to the
software" anyway.
The tables and relationships are:
tlbSoftware
SWID
Company
Title
MediaType
NumMedia
NumLic
NumLicAssg

tlbLicense Key.
ID - Auto Assign
SWID
License Key
CertificateNum
OrderNum
ExpDate
NoPerCert
LicNotes

tlbAssignments
ID - Auto Number
SWID
AssignedTo - Lookup that looks up the Tag# in the Equipment Table

What I would like is when you click the drop down box for the System # you
also see the name that is assigend to that system. The name is in a table
called Employees and is related based on the tblEmpAssignment.

I have a query that combines the first middel and last name and also has the
Equipment ID tag.
qurEmpAssignment
FName
MI
LName
Full Name: [FName]&" "&[MI]&" "&[LName]
IDTag

 

[Michelle]

I figured this out...however can you resize the lookup fields.
Right now it chops off the full name about half way so it looks something
like this...

|David Smi| XJ4568TU3 |
|Brenda Da| JUY76548T |

I would like it to show...
|David Smith | XJ5568TU3 |
|Brenda Davis | JUY76548T |

 

[John W. Vinson]

I figured this out...however can you resize the lookup fields.
Right now it chops off the full name about half way so it looks something
like this...

|David Smi| XJ4568TU3 |
|Brenda Da| JUY76548T |

Take a look at the ColumnWidths property of the Combo Box.