need to display fields from unrelated tables.

[dynamite9585]

My Database is coming along well, but coming into a bit of a pickle trying to make it do one of the sole functions i made it for.

we are required to fill out standized forms (on paper) for any course we want to attend.

i thought it would be simple enough to do since it's a word doc.

i successfully got the doc to display on the form and set about overlaying the fields from the tables in the right places.

i need to display data from table:ATP and from table: Personal Info.
these are in no way related to each other.

perhaps i'm going about this the wrong way, this ios not going to be used for data input (actually i want to lock it so records cannot be changed from here)

am i right to be using a form or is there another method?

EDIT: I did search the forum before and google, but gave up after 7 pages of results.

 

[PNGBill]

dynamite9585. You need to step back a bit and try to understand how a Database works.

All Data must be related. It is possible to have some data unrelated in the strict sence but this is often for other purposes such as performing calculations but normal Data has to be related or why bother having it in a database.

Another Fact is How can you handle Data that is not required for Data Input??
Yes you can add Controls to a Form that are not Bound to Tables but this Data is lost when the form Closes.

Maybe you just haven't described your issue clearly.

You can make a Form that is not linked to a Table only some of the controls are linked.

You can make this form replicate a standard form you already have on paper.

You can add data to this form.

You can make calculations with this data.

If you want to save any of this data, you will have to Save the data to a Table (Tables Store Data) before you close the form or all will be lost.

 

[dynamite9585]

the data that i want to put on the replicated paper form is sotred in 2 seperate tables. 1 form contains all the personal info (name age, next of kin, medical info ect), the other form contains the course information, (name of course, dates and location)

w ant to have it set up at the end of the day so that i can say: "i want to send this/these people on this course" and it will come up with the form filled out for each person so it just needs to be printed, signed and posted.

 

[dynamite9585]

had an idea last night that might fix my issue.
if i create a new table to store historical information on who i have sent on courses and use an append macor to recover personal infor and couse info to that table before taking it to the form.

does that sound as if it should work?

 

[PNGBill]

I have no idea how you setup your Tables and relationships but Yes, you should have a Table with Course History.

Off the Cuff, you should have the following tables:

TblStudents - Details of all people who are likely to be on a course or who have already gone on a course.

TblCourse - details of each Course that is available.

TblLecturer - Details of the Lecturers you have available to run courses.

TblAttendee - details of who attended what course with dates etc.

You may well need one or two other tables but this covers the basics.

You then setup your Relationships with only One Line between any two tables and only the "Join" fields repeated in other tables. eg StudentID will be in TblStudent (primary Key) and in TblAttendee as a field and not listed anywhere else.

The next step is to start collecting and manipulating the data and producing Forms (monitor) and Reports (printouts).

You can copy your database, remove sensitive data but leave a small amount of test data. Compact and repair and zip if necessary before attaching the database to your Forum Post for further assistance.

 

[dynamite9585]

no where near letting this go live yet. so there is only sample data at the moment.

it's there. have been playing with it today, cadetcourses table is my "inbetween" table

i don't need to concern myslef with lecturers as thats handled at the national level.