Easy Problem for you guru's....Missing Table After Using Layout Setup

I set up a relational database and it looked fine. I for some reason
went to layout setup and goofed it up. Now some of the fields say
"table missing." This doesn't make sense b/c some of the populated
fields come from the same table.

I tried to add a 3rd relationship and for some reason I cannot get
that information to populate and it doesn't give an error message.

Please Please help me.

Serious deadline.

Thanks!
Techy Wannabe [ Mi, 15 August 2007 01:20 ] [ ID #1795937 ]

Re: Easy Problem for you guru's....Missing Table After Using Layout Setup

On Aug 14, 5:20 pm, Techy Wannabe <jamiepowellsm... [at] gmail.com> wrote:
> I set up a relational database and it looked fine. I for some reason
> went to layout setup and goofed it up. Now some of the fields say
> "table missing." This doesn't make sense b/c some of the populated
> fields come from the same table.
>
> I tried to add a 3rd relationship and for some reason I cannot get
> that information to populate and it doesn't give an error message.
>
> Please Please help me.
>
> Serious deadline.
>
> Thanks!

There's tables and then there's table occurences. Tables store data.
Table occurences are the avenues through which data is accessed. Your
tables exist, but the table occurence has been deleted from the
relationship graph. You need to add it back and double click each
field to connect to that TO.
Grip [ Mi, 15 August 2007 06:59 ] [ ID #1795939 ]

Re: Easy Problem for you guru's....Missing Table After Using Layout Setup

"Grip" <grip [at] cybermesa.com> wrote in message
news:1187153986.266257.137920 [at] q4g2000prc.googlegroups.com...
> On Aug 14, 5:20 pm, Techy Wannabe <jamiepowellsm... [at] gmail.com> wrote:
>> I set up a relational database and it looked fine. I for some reason
>> went to layout setup and goofed it up. Now some of the fields say
>> "table missing." This doesn't make sense b/c some of the populated
>> fields come from the same table.
>>
>> I tried to add a 3rd relationship and for some reason I cannot get
>> that information to populate and it doesn't give an error message.
>>
>> Please Please help me.
>>
>> Serious deadline.
>>
>> Thanks!
>
> There's tables and then there's table occurences. Tables store data.
> Table occurences are the avenues through which data is accessed. Your
> tables exist, but the table occurence has been deleted from the
> relationship graph. You need to add it back and double click each
> field to connect to that TO.
>

is the layout setup pointing to the proper table?
Guy [ Mi, 15 August 2007 15:34 ] [ ID #1795942 ]

Re: Easy Problem for you guru's....Missing Table After Using Layout Setup

On Aug 15, 7:34 am, "Guy" <g... [at] guym.com> wrote:
> "Grip" <g... [at] cybermesa.com> wrote in message
>
> news:1187153986.266257.137920 [at] q4g2000prc.googlegroups.com...
>
>
>
> > On Aug 14, 5:20 pm, Techy Wannabe <jamiepowellsm... [at] gmail.com> wrote:
> >> I set up a relational database and it looked fine. I for some reason
> >> went to layout setup and goofed it up. Now some of the fields say
> >> "table missing." This doesn't make sense b/c some of the populated
> >> fields come from the same table.
>
> >> I tried to add a 3rd relationship and for some reason I cannot get
> >> that information to populate and it doesn't give an error message.
>
> >> Please Please help me.
>
> >> Serious deadline.
>
> >> Thanks!
>
> > There's tables and then there's table occurences. Tables store data.
> > Table occurences are the avenues through which data is accessed. Your
> > tables exist, but the table occurence has been deleted from the
> > relationship graph. You need to add it back and double click each
> > field to connect to that TO.
>
> is the layout setup pointing to the proper table?

That's really hard to say without looking at the file.
Grip [ Mi, 15 August 2007 17:22 ] [ ID #1795943 ]

Re: Easy Problem for you guru's....Missing Table After Using Layout Setup

On Aug 14, 11:59 pm, Grip <g... [at] cybermesa.com> wrote:
> On Aug 14, 5:20 pm, Techy Wannabe <jamiepowellsm... [at] gmail.com> wrote:
>
> > I set up a relational database and it looked fine. I for some reason
> > went to layout setup and goofed it up. Now some of the fields say
> > "table missing." This doesn't make sense b/c some of the populated
> > fields come from the same table.
>
> > I tried to add a 3rd relationship and for some reason I cannot get
> > that information to populate and it doesn't give an error message.
>
> > Please Please help me.
>
> > Serious deadline.
>
> > Thanks!
>
> There's tables and then there's table occurences. Tables store data.
> Table occurences are the avenues through which data is accessed. Your
> tables exist, but the table occurence has been deleted from the
> relationship graph. You need to add it back and double click each
> field to connect to that TO.

Thanks!
Techy Wannabe [ Fr, 17 August 2007 00:30 ] [ ID #1796783 ]

Re: Easy Problem for you guru's....Missing Table After Using Layout Setup

On Aug 15, 8:34 am, "Guy" <g... [at] guym.com> wrote:
> "Grip" <g... [at] cybermesa.com> wrote in message
>
> news:1187153986.266257.137920 [at] q4g2000prc.googlegroups.com...
>
>
>
>
>
> > On Aug 14, 5:20 pm, Techy Wannabe <jamiepowellsm... [at] gmail.com> wrote:
> >> I set up a relational database and it looked fine. I for some reason
> >> went to layout setup and goofed it up. Now some of the fields say
> >> "table missing." This doesn't make sense b/c some of the populated
> >> fields come from the same table.
>
> >> I tried to add a 3rd relationship and for some reason I cannot get
> >> that information to populate and it doesn't give an error message.
>
> >> Please Please help me.
>
> >> Serious deadline.
>
> >> Thanks!
>
> > There's tables and then there's table occurences. Tables store data.
> > Table occurences are the avenues through which data is accessed. Your
> > tables exist, but the table occurence has been deleted from the
> > relationship graph. You need to add it back and double click each
> > field to connect to that TO.
>
> is the layout setup pointing to the proper table?- Hide quoted text -
>
> - Show quoted text -

Yes. It all looks great now!

Thanks.
Techy Wannabe [ Fr, 17 August 2007 00:31 ] [ ID #1797790 ]
Datenbanken » comp.databases.filemaker » Easy Problem for you guru's....Missing Table After Using Layout Setup

Vorheriges Thema: auto enter value based on previous record
Nächstes Thema: Number formatting oddity with SQL