cannot add records in a portal due to calculation field ?

[KHaber]

I have created fields "formula id" and "formula name" which are each calculations (concatenation) of two other fields.

On my layout I have these two fields and then a portal in which I am trying to add records (from two different drop down value lists).

My drop down list shows...but when I try to select one of the choices, I get the error:

This action cannot be performed because this field is not modifiable.

From previous posts, I can see that the problem is somehow related to my calculation fields but I don't know how to fix the issue.

Also...I do not know how to attach a copy of the file or any screen shots to this forum so someone can see what I've actually done.

Can anyone help ?? I can email the file (it's really small).

Thanks much

Karen

[aldipalo]

To upload a file or picture:

goto reply or edit

Click on manage file

Click on browse

Go To the folder where the file or picture is on your hard drive

Highlight the file

Click Open

Click Add

When the file is loaded click finish.

hth

[KHaber]

THANK YOU FOR THAT HELP UPLOADING MY FILE:

Re: Problem adding records from drop down list in a portal...

Looking at the file again (and again and again), I really think my problem stems from not knowing how to do

the join tables properly.

I have

TABLE: PROGRAMS

Field: Program ID

Field: Program Name

TABLE: FORMULAS

Field: Formula ID

Field: Formula Name

TABLE: BOTANICALS

Field: Botanical ID

Filed: Botanical Name

Join TABLE: PROGRAMS Items

Field: Program ID

Field: Formula ID I entered my PROGRAMS and then via a Portal

and a Drop Down list, I populated the one to many relationship

of each PROGRAM having several FORMULAS

Join TABLE: FORMULAS Items

Field: Formula ID

Field: Botanical ID I had entered my FORMULAS and then via a Portal

and a Drop Down list, I populated the one to many relationship

of each FORMULA having several BOTANICALS

Then, it gets a bit complicated:

All of my future fields need to be related to a COMBINATION of the FORMULA and the BOTANICAL (FB Combo).

So... BOTANICAL "Garlic" as used with FORMULA "SuperFood" will have a list of Therapeutic Uses

and then also

BOTANICAL "Garlic" as used with FORMULA "SuperFood" will have several Reference SOURCES

This is the ultimate goal of my database...to list the Therapeutic Uses and the related Reference SOURCES for each of these FB Combo items.

So...this is where I'm stuck.

I think I've messed up some of the join Tables... and this may be causing the problem with data entry of the Therapeutic Uses and the Sources.

herbalsolutions2-27-09__1.fp7.zip

[aldipalo]

Beware the Spider graph. You are/have developed a spider web of a relationship Table Occurrence Graph (TOG). Currently, the way you have it set up it is very difficult to follow the logic.

Go Here: Anchor-Buoy System

and download and read Kevin Franks "Anchor-Buoy" system. I know when I first started it helped me tremendously.

[KHaber]

Thank you for the tip regarding my "spider web".

I did download and go thru the PPT for Anchor/Buoy

While my database is probably not complicated enough to use that system...I can see how my TOG was confusing.

I have re-organized the TOG to make my relationships

more transparent."

Also...I have done some data entry in the F/B Combo - Therapeutic Uses & Sources" Layout, which hopefully demonstrates what I am trying to do with my database.

Right now, everything is in order for me to be doing my research and entering the information, [color:red]but I am concerned because if I need to add FORMULAS, or update BOTANICALS, I am unsure of how the information will translate (add, update or delete from) the FB Combo table.

I also have some work to do down the road to produce meaningful reports...and allow for others to add, delete or change data, or perform FINDS. (But that is work for another day...or week).

herbalsolutions2-27-09__1.fp7.zip

[Fenton]

I may be missing something here. But it seems to me that Formula Items is the same as FM Combo.

[KHaber]

Yes...kind of.

I came up with the middle table FM Combo because I was unsure if a JOIN table could then add other fields which would be joined to another table.

I am going to rethink this today...