Subform link issue

[Tupacmoche]

Hi Form Masters,

I have a form that I inherited that has repeating columns in the tables. I was asked to add three (3) more repeating columns called Assignments 1 to 3 and now the additions 4 to 6. This should clearly go into a separate table where the user can add as many as needed.

On the main form side there are about 300 row in a table called Prospects that have been pre-selected that will be connected to or linked to the new Assignments table. The PK is an auto-increment number and I'm using it in the new Assignments table as a FK. I manually entered some of the PK numbers into the Assignment table's FK column and of course made a link between the master table Prospect.Uplaod_Number and related table Assignment.UpNumFK. Now, to the problem/Issue.

Since all the record in the master table already exist (they are pre-populated) the subform just sits there grayed out. The only time I see anything in it is where, I manually added the FK and a row to it. Additionally, it does not let me add new rows. When I tab through the subform (it has 4 columns) it simple tabs off of it. How can this be fixed and help is appreciated.

 

[June7]

Suggest you provide db for analysis. Follow instructions at bottom of my post.

 

[Tupacmoche]

Here is the script for both tables.

SELECTTOP (1000) [StrategyID]
,[UpNumFK]
,[StrategyAssignment]
,[StrategyNote]
,[StrategyDate]
,[StrategyStatus]
FROM [Med].[dbo].[CPM_Assignments]

-----------------------------------
USE [Med]
GO
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
CREATETABLE [dbo].[Campaign_Prosp_Mngmnt](
[Upload_Number] [numeric](18, 0)IDENTITY(1,1)NOTNULL,
[ID_Number] [nvarchar](20)NULL,
[Proposal_ID] [nvarchar](20)NULL,
[Name] [nvarchar](255)NULL,
[Ask Amount_(Sort Field)] [money] NULL,
[Interest/Giving Area] [nvarchar](4000)NULL,
[General_Strategy] [nvarchar](4000)NULL,
[Stage] [nvarchar](10)NULL,
[Plan_Status] [nvarchar](20)NULL,
[Tags] [varchar](2000)NULL
)ON [PRIMARY]
GO

 

[Tupacmoche]

I should also mention that the new record button on the record selector is grayed out.

 

[June7]

What should I do with that script? I only have Access to work with. Never worked with code like that and don't want to take time to figure it out. The issue might not be entirely with data, could be form design which is why I requested you provide file. If you can't or won't provide file, hope someone else can help you.