Entering data into a linked table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a linked table that has a field from three other tables.

The tables are:
Mag: MagID (PK), Title
Month: MonthID (PK), Month
Year: YearID (PK), Year
MagDetail: NumID (PK), Title (FK to Mag), Month (FK to Month), Year (FK to Year), VolNumber.

Sometimes I will not want to enter Month and Year for a particular magazine. In design view on the Lookup tab each of the FK's is a combo box, row source type-table, row source-a select statement, bound column-1, column count-2, column heads-no, column widths-0, list rows-8, list width-autho, limit to list-yes. What am I missing? I have looked at the Northwind Database and do not see anything different.

Thanks for the help
 
If you are using lookup fields in a table, consider reading this
http://www.mvps.org/access/lookupfields.htm.
Also, Month and Year are function names and should not be used as field or
object names. If you want to use combo boxes on a form, you should set the
widths for each column. Sometimes the first column is 0" wide to hide it and
display the "title" field.

--
Duane Hookom
MS Access MVP


Sharon said:
I have a linked table that has a field from three other tables.

The tables are:
Mag: MagID (PK), Title
Month: MonthID (PK), Month
Year: YearID (PK), Year
MagDetail: NumID (PK), Title (FK to Mag), Month (FK to Month), Year (FK to Year), VolNumber.

Sometimes I will not want to enter Month and Year for a particular
Click to expand...
magazine. In design view on the Lookup tab each of the FK's is a combo box,
row source type-table, row source-a select statement, bound column-1, column
count-2, column heads-no, column widths-0, list rows-8, list width-autho,
limit to list-yes. What am I missing? I have looked at the Northwind
Database and do not see anything different.
 
Back
Top