Jump to content

Repeating lookup field not looking up records


Manuel W.

This topic is 6120 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I have two database files, the first contains a layout which is similar to an invoice. The other contains one table which has all my inventory. Records are very simple-- an Inventory # in one field, and some other fields such as Description, Location, etc.

In the invoice form, I have the fields set up as repeating fields. When I type the Inventory # into the line 1 Inventory # field and hit Tab, the rest of the fields in line 1 lookup just fine and fill themselves in. However the remaining 6 repeating lines do not fill in!

I have a relationship defined between the two databases, specifically between the "Inventory #" fields on both. The inventory database can create records in the invoice database but not the other way around. The remaining fields in my invoice database are lookup fields.

Why is only the first line performing lookups? What more information do you need to know? I know this can work because I copied the layout almost verbatim from another FM db which I have on my computer, it works fine in there and I don't see any obvious differences.

Screenshots:

http://clearlightseattle.com/images/random/grab.jpg

http://clearlightseattle.com/images/random/grab2.jpg

http://clearlightseattle.com/images/random/grab3.jpg

Link to comment
Share on other sites

  • Newbies

Hello, Manuel,

I'm rowing the exact same boat at the moment re: repeating field lookups. Same problem, first field works great and none works after that.

Have you found a solution? I'll keep digging myself and post back if I come up with anything.

Kind Regards,

Steven

Link to comment
Share on other sites

With the introduction of fm7, was this changed ... and the move was correct, everyone with a lookup issue such as prices in an invoice need to have a normalized structure:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000717

Because the benefits are so overwhelming, say when someone needs to make some kind of statistics - is it much much easier with discrete records in a related table.

--sd

Link to comment
Share on other sites

This topic is 6120 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.