Jump to content

Plus Size and Searching


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

Recommended Posts

Greetings;

I am trying to add a calculation to the database that will automatically locate the lingerie that has a plus size.

Now to give an example:

Normal Size Wholesaler code might be: 5032

Plus Size Wholesaler Code might be: 5032X

I also have a field "Plus size Model number" that will set the field to "5032X" on the Normal Lingerie.

What i would like it to do, is normal lingerie record Compare "Plus Size Model Number" to records Wholesaler ID and see if that model number is located in there.

So it would search Wholesaler ID to see if there is a record 5032X if so "Yes" otherwise "No".

Any Ideas ?

Link to comment
Share on other sites

Instead of searching, you could define a self-join relationship linking your calculation field to the original field.

Okay, so i looked this up,

http://help.filemaker.com/app/answers/detail/a_id/3465/~/the-self-join-relationship%3A-what-it-is-and-some-examples-of-how-to-use-it

Just to confirm i would make the self join relationship on the fields "Wholesaler ID" and set "Plus Size" to Count(Wholesale ID No 1)

Is that right ? is that what you mean ?

Link to comment
Share on other sites

I am not sue what the names and types of your fields are. If you had a record like:

• WholesalerID = 456

• ItemCode = "5032"

and another one like:

• WholesalerID = 456

• ItemCode = "5032X"

and a calculation field cItemCodePlus =

ItemCode & "X"

then your relationship would be:

YourTable::WholesalerID = YourTable 2::WholesalerID

AND

YourTable::cItemCodePlus = YourTable 2::ItemCode

If this is for display only, you can simply place a field from YourTable 2 on the layout.

Link to comment
Share on other sites

Sorry, you have lost me there.

Okay, 10,000 Records, i want it to go though and search the Table "Product Catalog" and the Field "Wholesaler ID" to see if there are any records that match the value that is in "PlusSizeModel"

So the code for plus size model is "5023X", i want it to see if there is a record with the value of "5023X" in the table "Product Catalog".

Link to comment
Share on other sites

So the code for plus size model is "5023X", i want it to see if there is a record with the value of "5023X" in the table "Product Catalog".

But that's what the relationship does. If there is a record with WholesalerID = 456 and ItemCode = "5032X", it will be related. If you put the related fields on the layout, they will show data. If no such product exists, the fields will be empty.

Link to comment
Share on other sites

Sorry, I am not sure where you're stuck with this: once you set up the relationship as described, it will show the matching record for each product (if there is a matching record). Think of it as a "constant search".

I have (Product Catalog) joined to (Product Catalog 7) Via the following;

PlusSize Model = Wholesaler ID No 1

and Wholesaler Name = Wholesaler Name

and v_manafacture_name = v_manafacture_name

and on the Calculations i have PlusSize = Count(Product Catalog 7::Wholesale ID No 1)

I think that got it....

Now it seems to be displaying 1 if there is a Duplicate and 0 is there isnt a duplicate, is there a way of changing that so it shows "Yes" if there is a duplicate and "No" if there isnt instead of 1 and 0?

Link to comment
Share on other sites

Now it seems to be displaying 1 if there is a Duplicate and 0 is there isnt a duplicate, is there a way of changing that so it shows "Yes" if there is a duplicate and "No" if there isnt instead of 1 and 0?

Yes, change the number format of the field.

Link to comment
Share on other sites

This topic is 4296 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
 Share

×
×
  • Create New...

Important Information

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