Change field in one layout

[RICorp]

Hi i am newbie here and my english is not good i try to explain me

I make a sampledatabase with 2 fields but on i put 1 field

on 1 layout i want to create a script that when i clik a butom next field the first field change in the second field

is that possible because i need this to make my dbase so light as possible otherwise i have to make more than 20 layout for 20 different fields

i put a example

best regard ric

test.fp7.zip

[comment]

What are these 20 fields? Perhaps it would be better if they were 20 records?

[RICorp]

the fields are destinated for holes where i put in each different scores

so one layout that go on fmgo and its have to be not more than 1mb or 900ko

it better that the field change than to go to another layout with another field number

ex.

when i click give me field number 2

next click field 3 .....

but on one layout

best regard ric

[comment]

If this is something like golf, then you should definitely have a separate record for each hole. This would make the solution to your problem very easy - just go to the next record (or make a new record, if there isn't a next one). However, the main reason to do it this way is data normalization.

[RICorp]

Yes for my golf playing

I,did new record and put hole 2 ,image2 of the holes

but after 18 holes put new record is not practice i have to go back to hole 1.

i make a summary after that 18 play's that ok but to heavy layout with picture in in finisched the layout and send it

[comment]

I am afraid you may be missing my point. You should have (at least) two tables: one for Games, and one for Scores. Each score should be a separate record in the Scores table, with fields for the parent GameID and the hole number.

The attached file shows the proper data structure - as well as an idea how you could implement your interface requirement.

---

P.S. I know nothing about golf, so...

MiniGolf.zip

[RICorp]

that is what im looking for it make it and send you thhe final template

thank its going to help me the next butom that you make is good for the begin

best regard