"New Record created in wrong table"

[gunnerjoe]

Hi All,

I have never done much with database software and am new to Filemaker. We have Filemaker 8 Pro Advanced in my office so I thought I'd try something easy just to get the feel of the program and now I'm truly confused :

I want to create a database with two tables for tracking my Legato backups and Recoveries.

Table 1 has 6 fields

Table 2 has 4 fields

Neither of the tables are related in any way. I created two Layouts one for each of the tables and added a two buttons for a "New Record and Delete Record "

When I am in either Layout ( Browse Mode ) and Add a new record, it adds a new record in the other Table as well.

Why is this, am I missing some basic concept here?

Thanks,

Joe

Edited February 2, 2007 by Guest

[LaRetta]

Hi Joe,

FM creates new records (actually, performs ALL activities) based upon the table occurrence of the current layout (in the currently selected window). Drop into layout mode and select Layouts > Layout Setup. Make sure that the 'Show Records From' correctly specifies the right table occurrence.

If you are on that layout, a 'New Record' command will create a new record in THAT table. It sounds like you might have one of your layouts mis-specified to the other table occurrence.

UPDATE: If you can, Joe, please make your Subject Lines specific to your problem. All posts are questions and many are Newbies. Something such as "New Record created in wrong table" might have fit better. Why is this important? Because others use this Forum for searching for similar problems and they will never find this post if they search by subject. A small thing and many new people do it.

And WELCOME to FM Forums!!

LaRetta :wink2:

Edited February 2, 2007 by Guest
Added Update

[gunnerjoe]

Layout Setup was wrong on one of the Tables.

Thank You Very Much!

Joe