Hi lewiskidd, are you sure the error message says table "build" and not "building"? In a "one to many" relationship, you may not enter a record in your secondary table unless you have a related record in your primary table. You may have a record in the "one" table without any corresponding records in the "many" table but you may not have a record in the "many" table without a corresponding record in the "one" table. On 10/2/05, lewiskidd <[EMAIL PROTECTED]> wrote: > > I have been asked to build a database and I have attempted to do > just that, I have a single primary table called building and three > secondary tables. The relationship between the tables are a 1 to > many, that is to say the primary table has an instance of 1 and all > of the secondary tables have multiple instances and are therefore > classified as many. > > I have attempted to enter data into the database and it keeps > falling over, I have entered data into the primary table and it > appears to be fine as I am not encountering any error messages > here But! When I attempt to put data into the secondary table I am > met with a "You can not add or change a record because a related > record is required in table build" > > I have included primary and foreign keys throughout my table design, > I just can not see where the error is can someone please help me > with this. > > > Lewis > > > > > > > SPONSORED LINKS > Microsoft access > database<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+access+database&w2=Microsoft+access&w3=Microsoft+access+database+design&w4=Microsoft+access+database+training&c=4&s=131&.sig=_NMBmgHqxR8S8tjyGl-Tnw> > Microsoft > access<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access&w1=Microsoft+access+database&w2=Microsoft+access&w3=Microsoft+access+database+design&w4=Microsoft+access+database+training&c=4&s=131&.sig=-5Xf2KTU4AmC58h30Cq3wg> > Microsoft > access database > design<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database+design&w1=Microsoft+access+database&w2=Microsoft+access&w3=Microsoft+access+database+design&w4=Microsoft+access+database+training&c=4&s=131&.sig=rEvcpxWQYfjON1btwfI3Aw> > Microsoft > access database > training<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database+training&w1=Microsoft+access+database&w2=Microsoft+access&w3=Microsoft+access+database+design&w4=Microsoft+access+database+training&c=4&s=131&.sig=pILo23-rKYDuxPwf_IbrRQ> > ------------------------------ > YAHOO! GROUPS LINKS > > > - Visit your group > "AccessVBACentral<http://groups.yahoo.com/group/AccessVBACentral>" > on the web. > - To unsubscribe from this group, send an email to: > [EMAIL PROTECTED]<[EMAIL PROTECTED]> > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------ >
[Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
