Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #2824

Re: Can't Link Records

Show all headers | View raw

Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:

> On 2017-04-19 12:19:57 +0000, Charles H. Sampson said:
> 
> > My latest problem: I have a database containing six tables, four of them
> > related. (The other two are for accumulating data as scripts prepare
> > reports.) Two related tables have a simple many-to-one relationship.
> > Let's call the "one side" table A, the "many side" table B. I have a
> > layout for table A. It has a simple field linking to its related record
> > in Table B. That field is set up to use values from a drop-down list
> > with auto-completion.
> > 
> > This setup worked for a long time, then I lost the ability to enter data
> > into that linking field as I create new records for table A. Used to
> > work; stopped working;
> > 
> > I just created a portal in this same layout linking into table B. The
> > only field in this portal is the linking field. I'm unable to enter data
> > into that portal's field.
> > 
> > In both cases, when in browse mode the linking fields are dimmed and I'm
> > unable to even place the cursor into the linking fields.
> > 
> > This is for FileMaker Pro 8.0v3 on a G5 running 10.5.8.
> > 
> > TIA as usual.
> 
> Check that the fields is still set to allow user entry in the field 
> definition's Validation options and Auto-enter options. You may have 
> accidentally changed a setting.
>
I thought you might have hit on it, HH, but unless I'm misunderstanding
what you're saying, you didn't. The linking field on the "one" side has
nothng checked on the Auto-Enter page and the "Only during data entry"
radio button selected and the "Allow user to override during data entry"
box checked on the Validation page. Nothing else is selected or checked
on this page.  (These pages are from the "Options" display for the
field.) The same is true for the linking field on the "many" side.

Charlie
-- 
Nobody in this country got rich on his own.  You built a factory--good.
But you moved your goods on roads we all paid for.  You hired workers we
all paid to educate. So keep a big hunk of the money from your factory.
But take a hunk and pay it forward.  Elizabeth Warren (paraphrased)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Can't Link Records csampson@inetworld.net (Charles H. Sampson) - 2017-04-19 05:19 -0700
  Re: Can't Link Records ursus <ursus.kirk@gmail.com> - 2017-04-19 19:25 +0200
    Re: Can't Link Records csampson@inetworld.net (Charles H. Sampson) - 2017-04-21 11:06 -0700
  Re: Can't Link Records Helpful Harry <HelpfulHarry@BusyWorking.com> - 2017-04-20 10:01 +1200
    Re: Can't Link Records csampson@inetworld.net (Charles H. Sampson) - 2017-04-21 10:58 -0700
      Re: Can't Link Records Helpful Harry <HelpfulHarry@BusyWorking.com> - 2017-04-22 10:58 +1200

csiph-web