properly linking 3 tables in a form

[beidl]

Hi,

I'm trying to design a form around the following tables:

Table: Project Characters Scenes
--------- ------------- ---------
Fields: key: Name <-----> Name <------> Name
Director key: ID SceneNum
Producer Character <----> Character
key: ID
Take1
Take2

and I'm trying to get the form something like this:

CBX=combobox; TB=textbox;
==========================================form header
[CBX choose project Name]
------------------------------------------------------------- form detail
Project Details: Name, Director, Producer

[CBX Character]<-- one or all characters in Project
---------------------------------------------------------------- form footer
.........................................................................................|subform

|
[TB:SceneNum] [CBX: character] [TB:Take1][TB:Take2]|

|
.........................................................................................|
=======================================

what I'm trying to do is make it so the user can input a new scene and
choose the character from a combobox, (which must be included in the project
Name).

I want the subform to list all scenes in project Name, with the ability to
add new scenes, which must include a character. However, I need to be able
to sort the subform by a particular character or list for all characters. If
they choose to list all characters, then the subform character combobox
needs to show the current character. If they list ALL characters, how can
they change a character in the combobox? It will no longer meet the
criteria. A dilemma I'm facing is how can I make the subform table
updateable and still allow this functionality?

All help is appreciated! Thank you!

Gene

 

[beidl]

I'm moving my topic to the forms group.

Thank you.