So you basically got a big index table broken down into several smaller ones. This isn't really what is called a relational database --- its more like separate views of one big table which seems to be what alot of people seem to think makes it relational but that's not quite a true relational database.
Next if your key for each table is Roll Number then yes you must have it filled in on all tables because its your key field. If its not a key field then you absolutely do not have a relational table at all and your ability to do look ups is going to be a nightmare. As to how to populate your form with data you have two methods... you use VBA code to get record set and use that recordset to populate the form --- or you tie it to your database. I'm proponent of the first method but then I'm a programmer and doing it that way is just as easy as the other method and to me much safer in the long run. However, you can use the second method which seems to be what many strictly Access developers use because it doesn't require coding. If you need help with either of these methods... ?? You need to get a reference book ASAP. That's a lot to have to cover in an email. --- On Sun, 2/15/09, Kalyani Tirumala <[email protected]> wrote: From: Kalyani Tirumala <[email protected]> Subject: Re: [Access VBA Central] Creating Forms To: [email protected] Date: Sunday, February 15, 2009, 10:08 PM Here Roll No is the Primary key for all tables.. soo all tables are related with Roll No On 2/13/09, Dennis Jensen <djensen...@yahoo. com> wrote: > > I guess the two most obvious question and the one that has to be > answered are: > 1) How are all these tables related? > 2) How is the Roll related to these tables? > > --- On Fri, 2/13/09, kalyani_bommu <bommu.kalyani@ gmail.com<bommu.kalyani% > 40gmail.com> > > wrote: > > From: kalyani_bommu <bommu.kalyani@ gmail.com <bommu.kalyani% 40gmail.com> > > Subject: [Access VBA Central] Creating Forms > To: AccessVBACentral@ yahoogroups. com <AccessVBACentral% 40yahoogroups. com> > Date: Friday, February 13, 2009, 1:33 AM > > Hi, > I am creating a on-line Biodata form for that I have created 5 tables. > 1. General Table > 2. Education Table > 3. Experience Table > 4. Skills Table > 5. Extra curricular activities table > > Based on the Roll no i have to get the full information from all tables. > My questions are: > 1. Can I have to fill the Roll no for all tables? > 2. How can I get the data into Form? How can I do it? > Give me the suggestions. .. > > Thanks in Advance > Kalyani. > > [Non-text portions of this message have been removed] > > > -- Cheers, Kalyani. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
