J
John B. Smotherman
First, a bit of background: I'm working with a distributed db in Access2003
on WinXP. I've created a table (tblItems) with a one-to-many relationship
with another table (tblReceipts). The main table, tblItems, is displayed in a
form, frmItems. Normally I open this in form view, occasionally in datasheet
view. Because the db is distributed, I've made certain the subdatasheet for
all tables is set to [None], and when I open frmItems in datasheet view, no
subdatasheet is indicated by the plus sign at the left of the records.
Now the problem: I've created a second table, tblSoftware, with a
one-to-many relationship to tblItems. Now when I open frmItems in datasheet
view, the subdatasheet IS indicated by the plus signs, and when I expand one,
the fields from tblSoftware are shown. I've compared the design of
tblSoftware with tblReceipts, the relationships between these two tables and
tblItems, and the design of frmItems, and can find no obvious setting that's
causing the subdatasheet in frmItems. Any suggestions would be welcome.
THANKS!
on WinXP. I've created a table (tblItems) with a one-to-many relationship
with another table (tblReceipts). The main table, tblItems, is displayed in a
form, frmItems. Normally I open this in form view, occasionally in datasheet
view. Because the db is distributed, I've made certain the subdatasheet for
all tables is set to [None], and when I open frmItems in datasheet view, no
subdatasheet is indicated by the plus sign at the left of the records.
Now the problem: I've created a second table, tblSoftware, with a
one-to-many relationship to tblItems. Now when I open frmItems in datasheet
view, the subdatasheet IS indicated by the plus signs, and when I expand one,
the fields from tblSoftware are shown. I've compared the design of
tblSoftware with tblReceipts, the relationships between these two tables and
tblItems, and the design of frmItems, and can find no obvious setting that's
causing the subdatasheet in frmItems. Any suggestions would be welcome.
THANKS!