access table field question

[simplerequest]

Rural Guy are you still there?

[RuralGuy]

Yes indeedy. May I be of assistance?

[simplerequest]

Short on time i agrre i need to reorganize it i was afriad to delete tables
are you able to see my vision ?

I really thought this would be simple , well not simple but not complex in nature

what do you think?

[RuralGuy]

...are you able to see my vision ?

I'm sorry but not really. You seem to be trying to fill out the RecReports table but I have no idea what is needed in there. The important thing here is there is no reason to duplicate data in a RDBMS. Keys are duplicated in the tables but the actual data only resides in one table.

[simplerequest]

It is after 11pm. Is there a way to get the table to work, without using the combo boxes

[RuralGuy]

The ComboBoxes can be on the form, just not in the table. I'll play a bit but I really do not understand the table.

[RuralGuy]

Is the [cAmbulatory Services Surgery and] table where the [FACNUM] and [FACNAME] fields are home base? Is this the main table for this data? Who assigns the FACNUM?

[simplerequest]

You seem to be trying to fill out the RecReports table but I have no idea what is needed in there.

Answer:
The RecReports=rece ived reports. In this table I will enter the date I received the reports, how many I recieved, how many were submitted with treatment, how many are non reportable, the promary site and how many of each primary site were received.

(sorry that file did not have the complete design view page descriptions )


The info in RMCDS is the respones to a checklist. The information was entered in this table as I received the returned checklist.

I hope to enter the checklist into into a TAB on the NameForm. as a subform.
Another TAB on the name form would be the rec reports table.

[simplerequest]

yes that is the source

[simplerequest]

Rural Guy i just read your comment "This is the Datasheet view of the form and can be made the default if you want. You can not see the command button on your form in that view. "

Does the default then make it a table? Where I can enter and save the info?

Once I get the table to perform, I will just make a quick form, and use the form for data entry.

[RuralGuy]

Give me just a minute and I'll send you an email.

[RuralGuy]

email on the way. Let me know what you think.

[simplerequest]

cannot open zipped file

[RuralGuy]

What OS do you use? It should be on a right click of WinXP.

[RuralGuy]

Sent it again unzipped.