Alternative SKU

[Willie Sims]

The database I'm building has products with alternative sku's and I want to be able to enter all of the alts on the same product but then be able to have a search page that will show the result for that item even if it is searched by one of the alternative SKU numbers
So for example my current setup is SKU 12345 Alt-Sku1 54321 Alt-sku2 56789

On a separate remote form I have a SKU search box if any of those SKU numbers is typed in I want it to pull up the information from SKU 12345

Any tips on how I can do this

[MikeG]

I'd expect, in a relational database, you would have a Product form/table (one entry per product, holding a product identity and other product information) and a SKU form/table (one entry per SKU giving the associated Product identity). This allows you, for each product identity, to have an unlimited number of alternative SKU values.

Then, using Sailforms, your Product form can include a Remote Table field giving the list of associated SKUs from the SKU form entries,. This allows you, from a Product form entry, to add, edit, and delete associated SKUs. And in your SKU form you can link the associated Product form entry using a Search-List-Get Required connection, and you can also include Remote Fields to display other information from the Product form entry that is useful in that context.

I've attached a simple example.

Mike