without given roll no in every table can i give relationship to all tables. when i design form in MS-Frontpage based on Roll No i need to get the results from database. that is the reason i have taken roll no in every table.
On 2/16/09, Dennis Jensen <[email protected]> wrote: > > 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]<bommu.kalyani%40gmail.com>> > wrote: > > From: Kalyani Tirumala <[email protected]<bommu.kalyani%40gmail.com> > > > Subject: Re: [Access VBA Central] Creating Forms > To: [email protected] <AccessVBACentral%40yahoogroups.com> > 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] > > > -- Cheers, Kalyani. [Non-text portions of this message have been removed]
