Creating a spreadsheet type entry system for records

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
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.
Click to expand...

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
 
Back
Top