Search results

ok, there won't be a huge amount of fields on any of the 4 tables so they could be amalgamated at that level. so when I create my form where do I go? i have all my student info at the top of the form (from my studentinfo table), then a selection : deferral, year out etc. Would a button with a...

Thanks for the reply, Student table holds basic details, id no (primary key), name,address etc. Category table is 1. Deferral 2. Year Out 3. Extension 4. Subject Change The data elements in these 4 cats. would have little in common. A student could be in more than one cat. during the course...

Apologies in advance for the very basic knowledge required. I want to find the best way to design the following: I'm creating a database for use in a faculty office, to hold info on students in 4 categories- deferral, extension, subject change, year out. So I have a student table, a categories...

will give it a go - thanks for that.

Thanks for that! I should have emphasised that although a student could possibly be entered in one or more categories, this would be the exception. Most will be entered in one category only. So my main query is what is the best way to search all 4 tables from the entry screen? Would a separate...

Hi, I'm creating a database with 4 options - Deferrals, Extension, Year Out, Subject Change. Each one is a table / form with details of students who fall into that particular category. Each form has the following fields in common: First Name, Last Name, ID, Category (D, E, YO or SC). A student...