One layout messing up another layout

[TaiChi56]

I have two different layouts that I print just the records that have a tax amount. One tax amount is for one person and the other for another. When I go to print it shows that I have 244 records out of 1066 that have tax. I print that out and close the file. The other file has 99 records out of 1066 that has a tax amount.

Now the problem is when I go to to my Full Inventory layout and click on the button, instead of showing me all 1066 records, it shows me 244 records out of the 1066 or 99 out of 1066,depending which tax file I just printed out.

Here is the script I run for the tax file:

Go to layout [Tax amount by seller" (rifles)]

Perform Find [Restore]

Print [Restore]

Show all records

What should I be putting in this code or the coding in the Full inventory list that will put everything back to normal? In other words reset the database. It looks like the database is staying at which ever state the last tax amount find displayed.

If I run my full inventory first I get all the records. What am I doing wrong? Thank you.

[CyborgSam]

It sounds like the layouts have different underlying Table Occurences, in which case each will have its own Found Set. Are you positive that the script step Show All Records is executed while still on the same layout the Find is on?

[TaiChi56]

I am not positive. I will check and let you know. Thank you for answering.

[TaiChi56]

Ok, I checked and I have both scripts looking at the same layout. I even changed the full inventory script to original layout and I am still getting the tax amount found set showing up on the full inventory. If I run the full inventory first I get the whole inventory. But if I run any of the tax amount inventory then that found set will show up when I run the full inventory. Any other ideas I can try. It is starting to drive me crazy. Thank you.

[TaiChi56]

I cannot figure out why I cannot get all records when I go to my full inventory after I have ran a tax amount record. If I run the tax record first it will stay in the found set when I go to the full inventory. I can click on the "Show all record" icon and all my records come back. How do I script so when the user goes back and check the full inventory they will be seeing all the files?

[LaRetta]

I print that out and close the file. The other file has 99 records out of 1066 that has a tax amount.

You have confused me on what you have. Do you have ONE table, two tables, or two FILES??? You are mixing terms. It sounds more like you have two FILES. And they EACH have 1066 records in them. I suggest you post your file(s) if you can. We'll help you figure it out - I promise!!

LaRetta

[TaiChi56]

Ok, here is the file. It will show 1077 records but I deleted all but about 19 of the records. It still does the samething. Figured did not need all that info out on the Internet.

When you open it, just click on Guest, it has full admin rights.

If you click on Tax=TH you will get 10 records. Now if you go to form view and click on Full Inventory you will also get 10 records out of 1077. I should be showing all 1077 records. Hope this makes sense now that there is a sample to look at.

Thank you for helping.

Armory_Copy.zip

[LaRetta]

Oh God. I know this. Been there several times. You've crashed this file. The 'missing records' problem.

Update: It appears to be acting normally. But if you create a table view, it shows 177 records but all but 19 are blank. I doubt that you 'cleared' all fields so it's suspect to me.

But still ... it appears to be acting normally now - adding new records, etc... But your finds were failing because there is NO DATA. Whether because your file trashed or you blanked all fields, is another matter ... I'll test it a bit more ...

[LaRetta]

Your file allowed me to Find all blank records and delete them. When I've tried that with a trashed file (search for * in text field), it finds records that appear blank (indicating they have data anyway). Your file is NOT behaving as tho it's been trashed (at least not like my experience of it). And figures are reflected correctly in your Define Database > Tables tab, listing 18 fields, 19 records now.

I don't think your file is trashed. Possibly you somehow blanked all fields? It would have helped if you would have had a CreationDate or something which ALWAYS lists. Then we'd know for sure because if one of THOSE fields were blank also, it'd be trashed. It is responding normally now. But your Finds were looking for data in fields and you didn't have any.

Edited November 9, 2005 by Guest

[LaRetta]

I've gone clear through your file. I think it is fine. Here is what I observed:

You have one unstored calculation called Total with: Case (WholeSale = "Yes"; 0; Sales Tax * Sale Amount)

All 177 records display a 0 in that Total field (implying FM is identifying them as legit records). And when I change data (which alters the Total calculation), it changes properly. I've ran several tests (adding data and records) etc. Your Find simply fails because your records are blank.

[TaiChi56]

Maybe I did not explain it right. Here is an example:

1. User clicks on the Tax = TH and it shows there are 10 records out of the 1077 that show he has paid tax. (There are really more but I deleted all those files and left a zero in them).

2. Now the user prints this file and then goes back to the original layout.

3. Now the user decides to print out the whole inventory, so he clicks on the full inventory. Now that shows 10 out of 1077. It is not showing all records unless I click on the "Show all records" icon at the top.

My question is, shouln't it show all records? It is acting like it is staying in the find mode from the previous find on Tax = TH. Hope this clears it up.

So if the user wanted to print the full inventory out, he would not be getting the full inventory but 10 records that was searched from the previous find. Thank you for all your help.

[SlimJim]

Your Tax Amount by Seller, Full Gun Inventory and Gun Show Inventory Layouts are based on the TO Rifles. Form View is based on the TO Rifles Copy. This is why when you press the Full Inventory or Show Inventory buttons after doing a find on the Rifles TO you only see the records from the found set.

Without going into the logic of your file I cannot say how to fix it since changing the TO for the Inventory Layouts to Rifles Copy might solve this problem and create another.

EDIT: looking back I see that CyborgSam alerted you to this possibility and I also note that the script that you put into your original post is not the same as the script on the sample file posted. I have added in the extra steps to the Tax Amount by BT script - Print, Show all Records, Go To Layout[original] and it all seems to work OK to me. Namely you get the full inventory afterwards by pressing the Full Inventory button.

Edited November 9, 2005 by Guest

[TaiChi56]

Thank you with all the help I have fixed the problem. Yes, my tables were messing me up. The found set was referring to one and my full inventory list was referring to another one. The problem is fixed. Thank you to everyone for helping.