Home

"Array" fields in Access tables

%3CLINGO-SUB%20id%3D%22lingo-sub-875139%22%20slang%3D%22en-US%22%3E%22Array%22%20fields%20in%20Access%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875139%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20creating%20a%20%22Person%22%20record%20that%20has%20a%20field%20that%20my%20require%20more%20than%20one%20entry.%20Specifically%2C%20in%20a%20particular%20record%20I%20want%20to%20indicate%20a%20Spouse%20or%20Child.%20More%20specifically%2C%20there%20maybe%20more%20than%20one%20spouse%20or%20child.%20I%20don't%20see%20how%20the%20options%20on%20Field%20types%20offers%20such%20a%20thing.%20Am%20I%20missing%20something%20or%20do%20I%20just%20as%20many%20fields%20that%20I%20could%20possibly%20need%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-875139%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
jkreider
Occasional Visitor

I'm creating a "Person" record that has a field that my require more than one entry. Specifically, in a particular record I want to indicate a Spouse or Child. More specifically, there maybe more than one spouse or child. I don't see how the options on Field types offers such a thing. Am I missing something or do I just as many fields that I could possibly need?

 

1 Reply

@jkreider Welcome to the One to Many.

Just add tables :

Spouses to record all the spouses of a person

Kids to record all the kids of a person.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies