Entering data into a linked table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sharon - 30 Jun 2004 03:39 GMT

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

Signature

Sharon

Reply to this Message

Duane Hookom - 30 Jun 2004 03:50 GMT

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.

Signature

Duane Hookom
MS Access MVP

> I have a linked table that has a field from three other tables.
>
[quoted text clipped - 5 lines]
>
> 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

Reply to this Message