Plus Size and Searching

[Online Premium Trading]

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 ?

[comment]

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

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

[Online Premium Trading]

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 ?

[comment]

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.

[Online Premium Trading]

Yea, i already have the field with the Plus size model in it.. Want i want to do is get it so that it see's if there is a Wholesaler ID with that particular ID CODE.

So something like

If (Plussizemodel = Wholesaler ID; "Yes"; "No")

But get it to check all the records in that particualar table.

[comment]

But get it to check all the records in that particualar table.

Sorry, you have lost me there.

[Online Premium Trading]

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".

[comment]

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.

[Online Premium Trading]

So how do i set it up ?

how do i make it so that it searches the records under that table and see if there is a value in the field "Wholesaler ID" that matches the value of "PlusSizeModel"?

[comment]

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".

[Online Premium Trading]

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?

[Vaughan]

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.

[Online Premium Trading]

Yes, change the number format of the field.

Kool, something simular to what i want, but is there a way to actually get it to change the data to "Yes" & "No" instead of just changing the format ?