Creating a spreadsheet type entry system for records

[Mark]

Does anyone out there know how I could create a
spreadsheet type grid for entering records?? For example,
a parent table contains six dates. Those six dates would
become column headers for a table that contains, date,
part number, quantity. The six dates are column headers,
the part numbers are row headers and the quantity is what
is filled in the information section.

Thanks,

Mark

 

[Tim Ferguson]

Does anyone out there know how I could create a
spreadsheet type grid for entering records?? For example,
a parent table contains six dates. Those six dates would
become column headers for a table that contains, date,
part number, quantity. The six dates are column headers,
the part numbers are row headers and the quantity is what
is filled in the information section.

1) Use a subform, laid out as a datasheet or in continuous-forms

2) use Excel: a couple of lines of VBA will lay out the row and columns as
required, and a couple more will write the values back into the database

3) consider your design. "A parent table contains six dates" sounds awfully
like a candidate for normalisation.

Hope that helps


Tim F