Input data form

  • Thread starter Charles D Clayton Jr
  • Start date
C

Charles D Clayton Jr

A2K

I have a main table ("MainTable_CostCodes")that lists all the
CostCodes with a description and other pertinent information. I have
another table("subCostCodes_Qty") that has Dt(date), Qty (number) and
FK from the MainTable. It is related in a 1 to many.

I need to create a form for a person to input dates and qty for
CostCodes. There are around 30 CostCodes but you will not have a qty
for each CostCode every day. I need to be able to list all the
CostCodes on the form with a place for the person to enter a date and
hours next to whatever costcodes are being used. Does anybody have
any guidance on how to approach this problem?

Thanks,

Charles D Clayton Jr
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

two queries from same data in table into one query 2
Employee Time Database with "Banked Time" 3
CALCULATED VALUES FROM CURRENT VALUES IN AN ENTRY FORM 2
autofilter results based on cell input 5
collect data in a form control 2
adding records to a sub form 2
Input Date form 1
subform in main form 2

Top