Post Closed
27
Views
7
Comments
Save more than 1 identifier in one field
Application Type
Traditional Web
Service Studio Version
11.11.15 (Build 48647)

Hi All,


I want to create a feature when selecting a record and clicking save, the Id of the records will be stored in one column

Example:

I selecting record with id 1,2,3,4

and record with id 1,2,3,4 will be in a column called RECORD_ID


and record with RECORD_ID 1,2,3,4 will i I'll show it on the page.


Thanks and regards,

Kane 

Hello Kane,

Could you please provide any sample image for your requirement. So that we can easily understand your requirement.

Regards,

Ajit kurane.

mvp_badge
MVP

Personally I think the question is very clearly written.

Champion

Hi Kane Loony

If you really want to do this ,Then you need to change the filed's data type to Text.

But I don't think this is good idea. If you want to create 1-N relationship between two tables, You should create another table and set foreign key to the identifier.

Regards

Hi Tom,


Please, can you explain more detail


Thanks

Champion

Hi 

To learn about how to create a One-to-Many relationship, Please refer to this official document.

Regards,

mvp_badge
MVP

It seems in this case it's actually many-to-many.

mvp_badge
MVP

Hi Kane,

You have already asked a very similar question in this post, and you've been explained there that what you are trying to do is an anti-pattern. Don't do this!

I'm going to close this post, as two posts on one topic is too much.