Search results

I've looked over and over, and I can't find what triggers tblPatients and IPH1a/IHP2a to work, and not the same tblPatients with IHP1b/IHP2b. Would you mind having a look and tell me where the relationships go wrong. The structures look good to my opinion. I'd appreciate any help. At this...

Have u had a better look since i uploaded the database?

Have u had a better look since i uploaded the database?

Enclosed a snapshot of relationship. Yes, this exercise is to capture elctronically a paper questionnaire. There are actually 8 questionnaires: Initial History, Follow-Up, Missed Visit, Labs, Adverse Event Log, Serious Adverse Events, Discontinuation, and Death.

There has been some confusion from start, and i was meant to say "300-500 fields on the paper form, with a result of building up to 4 tables to accomodate it. Please have a look at the attachment CEMART-v2011.ZIP and you'll soon realize what i mean. frmMainMenu is the starting point: say you...

When i wrote earlier that "...forms that have 300 and some others 500 fields", i was referring about the paper forms used at the clinics. Every principal investigator comes with their own research questions, and this one in particular ended up with 4 to 7 pages of questions in a single paper...

i followed the rules of uniqueness and keys (primary and foreign keys), and the database has its optimal structure and is close to 3rd nominal form. The way all tables are linked is of the following: The main interface has an unbound combobox with AfterUpdate and NotInList events that...

I've programmed a complex database for clinic follow-ups; it's all done. There are 9 forms, some are used only once and others have as many records as the number of clinic visits done by the patient. Some forms are fairly simple with maybe 120 fields, but my biggest issue is with the forms that...